Excel query layer using SQLite SQL

Bud — Fri, 14 Jun 2024 02:47:39 GMT

It's my guess that ArcGIS Pro loads Excel spreadsheets into a table in memory, and that allows Pro to use SQLite SQL expressions on the spreadsheet. ArcGIS Pro uses the SQLite SQL dialect for expressions on Excel files?

I'm wondering if that could be taken a step further: Not only allow SQLite SQL expressions (definition queries, Select By Attributes, etc.) but also allow full-blown SQL SELECT queries on the in-memory Excel table.

For example, a query that could Split comma separated values to multiple rows, but using the recursive WITH clause in SQLite (dynamic), instead of Python (static output). There would be lots of other uses, too.

If the spreadsheet is already loaded into an in-memory SQLite table, then why not allow full SQLite queries on the SQLite table? I think that would really bolster ArcGIS Pro's dynamic analysis capabilities.

idea Excel query layer using SQLite SQL in ArcGIS Pro Ideas

Excel query layer using SQLite SQL