https://community.esri.com/t5/arcgis-insights-ideas/expression-language-with-sql-capability/idi-p/1309511 <P>Ability to use the Expression Language available in Insights with SQL capability. That is to say functionality like "<EM>select * from table1&nbsp;where PK in (select FK from table2)</EM>" 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.&nbsp;</P> Wed, 19 Jul 2023 14:08:13 GMT PaulDowning 2023-07-19T14:08:13Z https://community.esri.com/t5/arcgis-insights-ideas/expression-language-with-sql-capability/idi-p/1309511 <P>Ability to use the Expression Language available in Insights with SQL capability. That is to say functionality like "<EM>select * from table1&nbsp;where PK in (select FK from table2)</EM>" 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.&nbsp;</P> Wed, 19 Jul 2023 14:08:13 GMT https://community.esri.com/t5/arcgis-insights-ideas/expression-language-with-sql-capability/idi-p/1309511 PaulDowning 2023-07-19T14:08:13Z https://community.esri.com/t5/arcgis-insights-ideas/expression-language-with-sql-capability/idc-p/1312313#M380 <P>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.&nbsp;</P> Wed, 26 Jul 2023 21:00:31 GMT https://community.esri.com/t5/arcgis-insights-ideas/expression-language-with-sql-capability/idc-p/1312313#M380 AkshayHarshe 2023-07-26T21:00:31Z