Enable SQL Expressions in Data Pipelines

[michelle-maps]

When pulling in data from Data Pipelines, I would love the option to enter a raw SQL query rather than interacting with a series of dropdowns from the SQL builder.

I oftentimes have a large number of attributes I would like to filter by,  and having to select each item one-by-one is cumbersome.

Additionally, I had run into a apostrophe/quote backend escaping bug that I think would have been avoided if I were able to just type the query in.

I know this functionality lives in other Esri products (for example, the definition query modal in ArcGIS Pro), so hoping it would be possible in Data Pipelines!

[VenkataKondepati]

I completely agree with this — having the ability to type or paste a raw SQL query in Data Pipelines would make filtering much faster and more flexible. The dropdown builder works for simple cases, but when you’re dealing with many attributes or complex conditions it becomes cumbersome.

We already have this kind of functionality in other Esri tools like the definition query dialog in ArcGIS Pro, so it makes sense to extend it here as well. It would also help avoid issues like escaping bugs, since users could control the query syntax directly.

+1 to adding a raw SQL editor option alongside the builder.

Regards,
Venkat