I’m sure this question has been asked more than once in the past - but is there any plans to incorporate windowing functions, without using a derived table. They are incredibly useful (I’m using SQL Server), so a big restriction.
With a derived table, you will often want to pass the runtime filters on the explore to it (and there could be many dimensions, with new ones added at any time). A native derived table with the SQL windowing function in a derived column and bind_all_filters get’s around this. But it cannot of course be a PDT so performance will take a big hit.