## 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/schema.py
ActionsNode = "ActionsNode"
    EventsNode = "EventsNode"
class RetentionEntity(BaseModel):
    model_config = ConfigDict(
        extra="forbid",
    )
    custom_name: Optional[str] = None
    id: Optional[Union[str, float]] = None
    kind: Optional[Kind] = None
    name: Optional[str] = None
    order: Optional[int] = None
    type: Optional[EntityType] = None
    uuid: Optional[str] = None
class RetentionReference(str, Enum):
    total = "total"
    previous = "previous"
class RetentionPeriod(str, Enum):
    Hour = "Hour"
    Day = "Day"
    Week = "Week"
    Month = "Month"
class RetentionType(str, Enum):