## Is your feature request related to a problem?

It's currently not at all obvious that we apply a `LIMIT 100` clause to HogQL queries. This leads to confusion, like here: ZEN-9555.

## Describe the solution you'd like

We can probably get away with just some note somewhere.
Better yet, an "apply higher limit" button in the "reached end of results" message.

#### *Thank you* for your feature request – we love each and every one!

posthog/hogql_queries/insights/paginators.py
"""
    Paginator that fetches one more result than requested to determine if there are more results.
    Takes care of setting the limit and offset on the query.
    """
    def __init__(self, *, limit: Optional[int], offset: Optional[int]):
        self.response: Optional[HogQLQueryResponse] = None
        self.results: list[Any] = []
        self.limit = limit if limit and limit > 0 else DEFAULT_RETURNED_ROWS
        self.offset = offset if offset and offset > 0 else 0
    @classmethod
    def from_limit_context(
        cls, *, limit_context: LimitContext, limit: Optional[int], offset: Optional[int]
    ) -> "HogQLHasMorePaginator":
        max_rows = get_max_limit_for_context(limit_context)
        default_rows = get_default_limit_for_context(limit_context)
        limit = min(max_rows, default_rows if (limit is None or limit <= 0) else limit)
        return cls(limit=limit, offset=offset)
    def paginate(self, query: ast.SelectQuery) -> ast.SelectQuery:
        query.limit = ast.Constant(value=self.limit + 1)
        query.offset = ast.Constant(value=self.offset)
        return query
    def has_more(self) -> bool:
        if not self.response or not self.response.results:
            return False
        return len(self.response.results) > self.limit
    def trim_results(self) -> list[Any]: