sqlstring -- a library to build a SELECT statement

Tim Roberts timr at probo.com
Fri Oct 21 02:13:06 EDT 2005


"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.
-- 
- Tim Roberts, timr at probo.com
  Providenza & Boekelheide, Inc.



More information about the Python-list mailing list