sql-metadata
sql-metadata copied to clipboard
LIKE operator pattern detected as column
Pattern to be searched when using LIKE operator is being detected as a columns.
Code to reproduce the result, using sql_metadata==2.10.0
from sql_metadata import Parser
sql_string = "select * from cars where description like %fast"
parser = Parser(sql_string)
print(parser.values)
This code gives the result ['*', 'description', 'fast']