search

barklan / inline_sql_syntax

Highlight and lint inline SQL strings.
https://marketplace.visualstudio.com/items?itemName=qufiwefefwoyn.inline-sql-syntax
MIT License
58 stars 25 forks source link

Semicolumn in string in SQL can end the query and raise "Unmatched parentheses" error #107

Open Leroymilo opened 1 year ago

Leroymilo commented 1 year ago

Something like :

SELECT series_id, GROUP_CONCAT(auth_name SEPARATOR '; ') AS auths
FROM Authors
NATURAL JOIN `Series-Authors`
GROUP BY series_id

will be considered an "Unmatched parentheses" error with red squiggles everywhere because the semicolumn ; used as a separator here is considered the end of the query, which causes the closing parenthesis to be in 'another' query.

I'm working in python 3.10, inline sql syntax 2.16.0.