Today we’re releasing the #1 most requested SQL editor feature: support for multiple SQL statements in one query. Hello, temp tables!
Using multiple SQL statements, you can do much more than pull data back from the database. You can add variables and functions, manipulate data, define search paths, and even create temp tables.
For example, suppose you’re writing a query that references the same aggregated dataset several times. You can use multiple statements to first create a temporary table of these aggregated values, and then run your query against that table, potentially making your query run much faster.
One more to go!
We’re so excited to get this powerful feature into your hands. Be sure to keep the questions and product feedback coming—we’re here to help!
Looks like you've got a thing for cutting-edge data news.
So do we. Stay in the know with our regular selection of the best analytics and data science pieces, plus occasional news from Mode. Sign up here and we'll keep you posted: