## 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
from typing import Any, Optional, cast
from posthog.hogql import ast
from posthog.hogql.constants import (
    get_max_limit_for_context,
    get_default_limit_for_context,
    LimitContext,
    DEFAULT_RETURNED_ROWS,
)
from posthog.hogql.query import execute_hogql_query
from posthog.schema import HogQLQueryResponse
class HogQLHasMorePaginator: