shatteredsilicon / ssm-submodules

GNU Affero General Public License v3.0
0 stars 2 forks source link

QAN: When a query uses views, SELECT in the view should be parsed and underlying views and tables should also have definitions shown #192

Closed gordan-bobic closed 10 months ago

gordan-bobic commented 10 months ago

When a query uses views rather than tables, view definitions are shown. To improve visibility of what what the query does: 1) The view definition was "beautified" the same way query examples are, broken up across several lines. 2) The SELECT part of each view should be parsed and underlying tables should be shown. 3) If a view is SELECT-ing from other views, the parsing and table definition gathering should be recursively carried out until all underlying views and tables are gathered.