Repository navigation
CTE column names #275
Description
Activity
For now parser does not infer tables so you need to prepend colum with source. Change
select pid from ctetoselect cte.pid from cteand it will work as expected.Change select pid from cte to select cte.pid from cte and it will work as expected
Thanks for the prompt reply. Unfortunately this is not possible in some cases since SQL development and parsing/analysis may be done by different parties/teams.
In my case, SQL statements are authored by several dev teams in the organization; then security team collects these SQL statements from logs and implements the SQL parser for aggregated analysis, so it is not possible for security team to alter the SQL used in this case.
I got some query like below (A CTE with a column renamed):
Currently,
parser.columnsproperty returns['id', 'pid'], however, I expect theparser.columnsto return columns not containingpidsince it is accessing columns via CTE. Currently, CTE names are not included in theparser.tablesproperty, but the columns for CTEs are included in theparser.columnsproperty, which seems not consistent.I would like to know:
Thanks.