Feature Request: Same display options as trends for SQL insights

Feature request

Is your feature request related to a problem?

There's a disparity in display options between UI insights and SQL insights.

UI insights:

SQL insights:

Describe the solution you'd like

Feature parity, or bringing the most useful display features into SQL insights

Particularly useful to have:

• Show values on series
• Show trend lines
• Statistical analysis

Describe alternatives you've considered

Try building the insight with the UI when possible.

Additional context

From: https://posthoghelp.zendesk.com/agent/tickets/36028 (moved to PostHog: https://us.posthog.com/project/2/support/tickets/39687)

Debug info

Kind: support

Target area: analytics

Report event: http://go/ticketByUUID/b5780ecc-664f-4741-8c01-70d6fc0e38b4

Session: https://us.posthog.com/project/sTMFPsFhdP1Ssg/replay/0198a53f-f13a-7b1f-b44c-3cd061a40f14?t=669

Exceptions: https://us.posthog.com/project/2/error_tracking?filterGroup=%7B%22type%22%3A%22AND%22%2C%22values%22%3A%5B%7B%22type%22%3A%22AND%22%2C%22values%22%3A%5B%7B%22key%22%3A%22%24session_id%22%2C%22value%22%3A%5B%220198a53f-f13a-7b1f-b44c-3cd061a40f14%22%5D%2C%22operator%22%3A%22exact%22%2C%22type%22%3A%22event%22%7D%5D%7D%5D%7D

Location: https://us.posthog.com/project/38983/sql

Persons-on-events mode for project: person_id_override_properties_joined

Start at the SQL insights page linked in the issue and compare its display controls with the UI insights example. Review how SQL insight results are rendered and identify the existing implementations for series values, trend lines, and statistical analysis. Done means the agreed display options are available in SQL insights with behavior matching the corresponding UI insights features.