Because Common SQL is geared towards ANSI SQL, by default it connects in ANSI mode. If another mode is required, it can be set at connection time.
For example, to make MySQL treat quotes as in ANSI without setting other ANSI features, do:
See the description of the
LispWorks Reference Manual