Comments with a single apostrophe in queries with parameters raise a syntax error

The error raised is:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':id' at line {insert_line_here}

🔴 Failing Case 1
Simple example

SELECT id
FROM users
WHERE
-- This comment with a single ' will break the parameter below it
id = :id;

🔴 Failing Case 2
Adding additional elements to the query does not affect it

SELECT id
FROM users
WHERE
username = "you" AND
-- This comment with a single ' will break the parameter below it
id = :id;

🔴 Failing Case 3
The minimum example

SELECT id
FROM users
WHERE
-- '
id = :id;

🔴 Failing Case 4
The quote does not need to be right before the parameter

-- '
SELECT id
FROM users
WHERE
id = :id;

💚 Passing Case 1
Replace parameter with a literal value

SELECT id
FROM users
WHERE
-- '
id = 1;

💚 Passing Case 2
Close the single quote

SELECT id
FROM users
WHERE
-- ''
id = :id;

💚 Passing Case 3
Move the quote after the parameter

SELECT id
FROM users
WHERE
id = :id;
-- '

No source files or tests are named in the issue. Start by reproducing the parameterized queries shown in the report and trace how SQL comments and named parameters are processed. Done means a single apostrophe in a comment no longer causes a syntax error while the listed passing and failing cases behave as expected.