sql-metadata
sql-metadata copied to clipboard
macbre
Uses tokenized query returned by python-sqlparse and generates query metadata
Results
102
sql-metadata issues
Sort by
recently updated
recently updated
newest added
Take this query: `SELECT CAST(SUM(CASE WHEN segment = 'Premium' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) AS premiumpercentage FROM gasstations WHERE country = 'SVK' ` The...
```from sql_metadata import parser sql = "SELECT COUNT(*) FROM examination WHERE 'Examination Date' > '1997-01-01'" from sql_metadata import Parser parser = Parser(sql) print(parser.columns) ``` Outputs: `[]` Expected output: `['Examination Date']`