Support Autocomplete for CTE tables

[EkkoG]

Description

For now, SQL Autocomplete works fine when select from a table in db

but when the table is a CTE, it will nothing at autocomplete options.

It test on the latest demo of Hue https://demo.gethue.com/hue/editor?editor=828642
With version 4.11.0 and db type is Hive.

[bjornalm]

Thanks @EkkoG for the suggestion. The CTE suport could indeed be improved. I'll open to see if we can get a community contribution for this improvement.

[grzegorz8]

Hi! Is there any update regarding this issue?

Having some experience with bison tool and compilers, I tried to investigate how to add this missing feature but the complexity is quite overwhelming for me (especially the logic in sqlParseSupport.js). I guess CTE should be handled in a similar query as sub-queries. With a bunch of some hints where to look at, I may try to invest more time in it.