Where can you use SQL beyond WHERE clauses in a File Geodatabase?

[AZendel]

I just ran across this help topic while researching a related issue: File geodatabases SQL reference. This has a lot of potential to be very handy. Where can you execute these statements that use concepts such as aggregations and joins? Is there somewhere in the Pro interface that I haven't noticed? In some geoprocessing tools? Or only in the FGDB API?

[Asrujit_SenGupta]

In a View comes to mind immediately: Create Database View (Data Management)

Check this for more uses: SQL reference for query expressions used in ArcGIS

In ArcGIS Pro, SQL expressions can be used in the following tools and locations:

• Select by attributes using the Select Layer By Attribute geoprocessing tool.
• Definition Query tab on the Layer Properties dialog box.
• Display filters tab in the Symbology pane.
• Create reports using the Create New Reports pane.
• Export tables using the Export Table geoprocessing tool.
• Export features using the Export Features geoprocessing tool.
• Use the Calculate Field geoprocessing tool to create an expression to perform simple or complex calculations on field values. You can also calculate multiple fields using Calculate Fields.
• Use Select to query data for further analysis.
• Use the Make Query Table geoprocessing tool to create a layer or table view.
• Use the Table Select analysis tool to select features from an input table and write them to an output table. You can also use the Make Table View geoprocessing tool to create a view from an input table or feature class.
• Use the Make Feature Layer geoprocessing tool to create a feature layer.
• Use the Make Query Layer geoprocessing tool to create a query layer.
• Create a view in a database or geodatabase using the Create Database View geoprocessing tool.
• Use the Append geoprocessing tool to append multiple input datasets into a target dataset.
• Use ProSDK Core.Data.QueryDef.

---

Not sure if all the above are applicable for a File gdb, but this gives you an idea.

[JoshuaBixby]

Thorough response, nice.  (Assuming generative AI didn't do it for you, but then maybe I should be impressed if it did)

[Asrujit_SenGupta]

😁Nah, all the info is from the second link directly.

[KenBuja]

You can use these in Arcade functions (Distinct, Filter, GroupBy, etc)