Can you create a table IN metabase?

I know it's not ideal, but can you create a permanent table in metabase (created by merging together several table via native query, or other function) that can be accessed by other queries?

Hi @saaballergies
You can use CTE or Sub-Query
There's work being done to add some persistence in upcoming versions:

But ETL should currently be done elsewhere, so Metabase just consumes the data.