Jaqy recognizes two types of comments.
Note that /* */ style block comment is not recognized by Jaqy.
When Jaqy recognizes block of text as comment, it is ignored without
transmitting the text to the database server. Otherwise, if the text
does not start with ., then it is considered as part of SQL statement,
and would be transmitted to the database server.
The main reason not to blindly stripping away all the comments is because
for databases that support query logging, being able to search for queries
using tokens buried inside comments is very useful.
-- a Jaqy line comment
-- The following two lines are executed together.
SELECT 1234; -------- Not recognized as Jaqy line comment
.rem a Jaqy block comment;
/* This is not recognized as a Jaqy block comment. It is transmitted
with the following SQL statement to the database server. */
/* You will see error messages since `;` at EOL indicates the end of a SQL
SELECT * FROM MyTable;