sql-metadata
sql-metadata copied to clipboard
For Dateadd function , DD and WK keyword is been considered as column names
its a Great piece of work, but a small bug, for the below query, DD and WK keyword is been returned as columns , which ideally its not. so appreciate your fix.
SQL_parser = Parser(""" select dateadd(dd,30, DateReleased), dateadd(WK,2, DateReleased) from test a """) SQL_parser.columns
Tip : probably adding DD WK YY/YYYY as reserved keywords and ignore from columns list.