Expression Language with SQL capability

407
1
07-19-2023 07:08 AM
Status: Open
Labels (2)
PaulDowning
New Contributor II

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. 

1 Comment
AkshayHarshe

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.