HogQL insight creation with PostHog AI

Feature request

Is your feature request related to a problem?

Use case: When batch updating a dashboard within PostHog with PostHog AI by pasting a list of updated SQL queries into the chat (e.g. you manage queries outside for a large client project), the PostHog AI keeps creating trend visualizations for the Table Visualizations.

Limitation (Reply from PostHog AI itself):
The original insights are HogQL SQL table queries, and I was creating Trends chart visualizations instead. That's a mismatch I can't fix automatically with the tools available, because create_insight only supports trends, funnel, and retention visualization types — not HogQL SQL table queries.

Describe the solution you'd like

Give PostHog AI the tools to create HogQL table queries, so that it can adjust the dashboards accordingly.

Describe alternatives you've considered

Updating every query manually with UI buttons (Nobody wants to do that for multiple insights in a row)

Additional context

Debug info

- [ ] PostHog Cloud, Debug information: [please copy/paste from https://us.posthog.com/settings/project-details#variables]
- [ ] PostHog Hobby self-hosted with `docker compose`, version/commit: [please provide]
- [ ] PostHog self-hosted with Kubernetes (deprecated, see [`Sunsetting Kubernetes support`](https://posthog.com/blog/sunsetting-helm-support-posthog)), version/commit: [please provide]

Start with the create_insight tool described in the issue and identify where support is limited to trends, funnel, and retention. Compare that limitation with the HogQL SQL table-query workflow used by the dashboard, and consider the batch-update use case complete when PostHog AI can create the requested table visualizations rather than converting them to trends.