Draft a SQL query from a data question and the database schema, with a short explanation of what it does.
Match report questions to schema fields and draft pivot SQL.
Get a pivot SQL query back in the chat thread, with totals explained and columns matched to your database schema.
Turn chat requests for ranked lists into schema-checked SQL.
Get a ranking SQL query in your chat thread, ready for review. See how the measure and ties determine each position.
Turn team count questions into SQL with clear counting units.
Get a SQL count query in the chat thread, with a clear note on what it counts and which conditions it uses.
Draft SQL from the schema for the requested period.
Get a SQL query for a date or date range in your report chat, with the time field and boundaries explained in the same thread.
Draft schema-based SQL for coworkers' data questions.
Get a SQL query and a clear explanation in the same chat thread as your question, with results when you allow them.
Turn metric definitions into SQL CASE groups for review.
You get a SQL CASE query that groups your metric by the rules you provide, plus clear explanations in the same request thread.
Draft multi-table queries from the keys in a teammate's question.
Get a SQL query with the joins and filters your question needs, plus a short explanation in the same help thread.
Draft staged SQL from analysis tickets for review before running.
Get a CTE SQL query or subquery draft on your analysis ticket, with each stage explained before you run it.