idea Enable SQL Expressions in Data Pipelines in Data Pipelines Ideas

Enable SQL Expressions in Data Pipelines

michelle-maps — Tue, 12 Aug 2025 17:26:19 GMT

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!

Re: Enable SQL Expressions in Data Pipelines

VenkataKondepati — Fri, 12 Sep 2025 20:14:15 GMT

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