sqlstring -- a library to build a SELECT statement

[Robert Brewer]

Tim Roberts wrote:
"grunar at gmail.com" <grunar at gmail.com> wrote:
> >
> >An Example:
> >
> >>>> import sqlstring
> >>>> model = sqlstring.TableFactory()
> >>>> print model.person
> >SELECT
> >person.*
> >FROM
> >[person] person
> 
> The [bracket] syntax is unique to Microsoft.
> Everyone else, including Microsoft SQL Server,
> uses "double quotes" to protect special characters
> in identifiers.

Except MySQL (at least 4.1), which uses backticks.
http://dev.mysql.com/doc/refman/4.1/en/legal-names.html


Robert Brewer
System Architect
Amor Ministries
fumanchu at amor.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20051020/64a31765/attachment.html>