## 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/hogql_query_runner.py
query: HogQLQuery
    query_type = HogQLQuery
    def to_query(self) -> ast.SelectQuery:
        if self.timings is None:
            self.timings = HogQLTimings()
        values = (
            {key: ast.Constant(value=value) for key, value in self.query.values.items()} if self.query.values else None
        )
        with self.timings.measure("parse_select"):
            parsed_select = parse_select(str(self.query.query), timings=self.timings, placeholders=values)
        if self.query.filters:
            with self.timings.measure("filters"):
                placeholders_in_query = find_placeholders(parsed_select)
                if "filters" in placeholders_in_query:
                    parsed_select = replace_filters(parsed_select, self.query.filters, self.team)
        return parsed_select
    def to_actors_query(self) -> ast.SelectQuery: