Ability to use the Expression Language available in Insights with SQL capability. That is to say functionality like "select * from table1 where PK in (select FK from table2)" so that we can use it as a filtering mechanism without the need for a inner join and so that filtering can be more expansive.
Whenever possible joins are queries, It is possible that we are already doing this with joins. Although this is a great idea and we have considered this in the past, we don't have plans for writing SQL in insights in the near future as it comes with a lot of security concerns.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.