Make Aggregation Query Layer — More intuitive table alias naming in SQL of output query layer

Bud — Fri, 14 Jun 2024 17:53:42 GMT

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB:

I've created a query layer using the Make Aggregation Query Layer tool.

This is what the SQL of the resulting query layer looks like:

I've formatted the SQL for easy viewing:

select 
    t.*,
    row_count
from 
    infrastr.strln_route t
inner join 
    (select 
        asset_id,
        count(*) as row_count
    from 
        infrastr.lc_events
    group by 
        asset_id
    ) s 
    on t.rdsec = s.asset_id

I can imagine that the FC is aliased as t for "target feature class". But why is the table aliased as s ? What does "s" stand for?

Could those aliases be improved so that they're more intuitive? For example:

FC for Feature Class; TBL for Table.
Or something better

Re: Make Aggregation Query Layer — More intuitive table alias naming in SQL of output query layer

BBicking1 — Fri, 14 Jun 2024 17:30:00 GMT

see comment here

https://community.esri.com/t5/arcgis-pro-ideas/make-aggregation-query-layer-indicate-what-table/idc-p/1492824#M30683

idea Make Aggregation Query Layer — More intuitive table alias naming in SQL of output query layer in ArcGIS Pro Ideas

Make Aggregation Query Layer — More intuitive table alias naming in SQL of output query layer

Re: Make Aggregation Query Layer — More intuitive table alias naming in SQL of output query layer