[Zope] Allowed SQL statements for ZSQL

[Dieter Maurer]

andreas rippel wrote at 2003-1-21 10:26 +0100:
 > I'm looking for the SQL grammar, which is allowed/supported by ZSQL.
Z SQL Methods do not restrict the SQL statements that can be generated.

There is just one condition. The database engine must understand it.

 > E.g. the point is, how does ZSQL support sql-transaction expressions.
 > E.g. "select NOW()" is a legal expression for MySQL, but causes a parse-error in ZSQL.
 > There seems to be a "standard" inclusion of a limit clause within ZSQL
 > for security and/or overflow reasons.
 > Does anybody know the grammar?
Usually, the limit addition is disabled, when you put "0" in the field
"Maximum rows to retrieve" ("Advanced" tab of Z SQL methods).


Dieter