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
argument to connect for details.
LispWorks User Guide and Reference Manual - 21 Dec 2011