Currently, in ArcGIS Pro, SQL field calculations are only possible for unversioned EDGB data.
SQL expressions support faster calculations for feature services and enterprise geodatabases. Instead of performing calculations one feature or row at a time, a single request is sent to the server or database, resulting in faster calculations.
Only feature services and enterprise geodatabases support SQL expressions. For other formats, use Python or Arcade expressions.
Using the SQL option for the Expression Type parameter has the following limitations:
- The option is only supported for Db2, Oracle, PostgreSQL, SAP HANA, and SQL Server enterprise geodatabases.
- Calculating field values on joined tables is not supported.
- Versioned and archived data is not supported.
- The ability to undo geoprocessing operations is not supported.
It would be helpful if SQL field calculation support could be expanded to versioned data too.
Specifically, traditional versioning, with the option to move edits to base.
