## 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
return self.to_query()
    def calculate(self) -> HogQLQueryResponse:
        return execute_hogql_query(
            query_type="HogQLQuery",
            query=self.to_query(),
            filters=self.query.filters,
            modifiers=self.query.modifiers or self.modifiers,
            team=self.team,
            workload=Workload.ONLINE,
            timings=self.timings,
            limit_context=self.limit_context,
            explain=bool(self.query.explain),
        )
    def _is_stale(self, cached_result_package):
        return True
    def _refresh_frequency(self):
        return timedelta(minutes=1)
    def apply_dashboard_filters(self, dashboard_filter: DashboardFilter) -> HogQLQuery:
        self.query.filters = self.query.filters or HogQLFilters()
        self.query.filters.dateRange = self.query.filters.dateRange or DateRange()
        if dashboard_filter.date_to or dashboard_filter.date_from:
            self.query.filters.dateRange.date_to = dashboard_filter.date_to
            self.query.filters.dateRange.date_from = dashboard_filter.date_from
        if dashboard_filter.properties:
            self.query.filters.properties = (self.query.filters.properties or []) + dashboard_filter.properties
        return self.query