I have a .exp SQL expression file that has the following SQL in it:
type = 'b'
If I load the .exp SQL expression into the tools listed in the SQL Expression documentation, most of the tools will automatically parse the SQL into the "clause mode" UI picklists.
For example, Select By Attributes tool:
However, the Make Query Table tool doesn't seem to parse the SQL into the UI picklists:
Could the tools in the list below be standardized so that loaded .exp files are consistently parsed into "clause mode"? (It looks like the Make Query Table tool is the only tool that needs to be enhanced.)
Also, could my other notes in bold be considered?
SQL reference for query expressions used in ArcGIS:
Within ArcGIS Pro, the SQL expression dialog box [it's not a 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.
- Doesn't parse the SQL into the "clause mode" UI picklists, unlike the other tools in this list.
- 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.
- Doesn't support .exp files or have an expression dialog.
I think this tool should either be removed from the list (since it doesn't have an expression dialog), or the Make Query Layer tool should be added to the list, since it is similar.
- Use the Append geoprocessing tool to append multiple input datasets into a target dataset.
- Use ProSDK Core.Data.QueryDef.
- These tools are missing from the list:
Related: Create Database View — SQL Expression Builder