## 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
if not self.response or not self.response.results:
            return []
        if self.has_more():
            return self.response.results[:-1]
        return self.response.results
    def execute_hogql_query(
        self,
        query_type: str,
        query: ast.SelectQuery,
        **kwargs,
    ) -> HogQLQueryResponse:
        self.response = cast(
            HogQLQueryResponse,
            execute_hogql_query(
                query=self.paginate(query),
                query_type=query_type,
                **kwargs,
            ),
        )
        self.results = self.trim_results()
        return self.response
    def response_params(self):
        return {
            "hasMore": self.has_more(),
            "limit": self.limit,
            "offset": self.offset,
        }