the syntax highlighter should colour schemas, tables, columns, types, functions differently

This would make parsing what is going on in a query much easier. While it is not a problem when writing queries in the editor, where one can follow ones own indentation rules and aliasing/naming conventions, it is very hard to make sense of view definitions which don't preserve these. Most of the view definitions end up being mostly black text with some blue keywords.


Start by reproducing the screenshot with a view definition and tracing the SQL syntax-highlighting entry point. Identify how identifiers are currently classified, then verify that schemas, tables, columns, types, and functions receive distinct highlighting in view definitions.

Written by the indexing model from the issue text.