Allow selection/SQL expression for all applicable geoprocessing tools

[Bud]

It would be helpful if all applicable geoprocessing tools allowed for:

• Using a map layer that has a selection as the Input Data, and...
• Apply an SQL expression/filter to the Input Data (as part of the GP tool)

I'm aware that we can work around tools where that functionality is missing, by creating a custom model and utilizing the Selection GP tool. However, I think that functionality should exist OOTB for all applicable tools.

In other words, I would like the ability to filter all GP tool input data parameters using SQL (using functionality right in the tool).

[Bud]

Related: SQL reference for query expressions used in ArcGIS

In ArcGIS Pro, the SQL expression dialog box can be found in the following 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.
• Use Select to query data for further analysis.
• Use the Make Query Table geoprocessing tool to create a layer or table view.
• Use the Make Feature Layer geoprocessing tool to create a feature 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.