Is your feature request related to a problem? Please describe.
When grouping a question by a time dimension using the GUI, the trend visualisation will display the relevant date range. However, for native SQL queries, we're unable to get this behavior and only get the start of the date range.

Describe the solution you'd like
Allow the end point of the date range to be returned from the SQL query in a second column and used in the date range string in the trend chart.

Describe alternatives you've considered
Being able to provide the entire date range string as a column would also solve the problem, and would be even more flexible.

How important is this feature to you?
Very useful, since at the moment there are some questions we can't express using the GUI (eg. get the totals for an arbitrary selected period that isn't necessarily one of the built-in time groupings, plus the prior period of the same length).

Additional context
This relates to the broader #48036, which was partly resolved by fixing a formatting regression.