By writing CTE you can use full functionality of SQL to select data and create intermediate tables for any transformation goals. Be careful if you use this CTE with JOINS and then with Data Extraction ...

Currently huge piece of SQL functionality couldn't be used in virtual datasets due to the fact that dataset query is being put into from section in a pattern "from ("SQL query") as virtual_table. This ...