Could SQL field calculation support be added for file geodatabases, similar to enterprise geodatabases?
That would let us take advantage of the power and simplicity of SQL. Including joins, subqueries, and GROUP BY, which are all supported in file geodatabase SQL.
SQL for reporting and analysis on file geodatabases