python拼接sql动态查询语句有更好的写法吗

Question

如题所述

Answer 1

可以使用现成的包
python-sql is a library to write SQL queries in a pythonic way.
Nutshell
Import:
>>> from sql import *
>>> from sql.aggregate import *
>>> from sql.conditionals import *

Simple selects:
>>> user = Table('user')
>>> select = user.select()
>>> tuple(select)
('SELECT * FROM "user" AS "a"', ())

>>> select = user.select(user.name)
>>> tuple(select)
('SELECT "a"."name" FROM "user" AS "a"', ())

>>> select = user.select(Count(Literal(1)))
>>> tuple(select)
('SELECT COUNT(%s) FROM "user" AS "a"', (1,))

>>> select = user.select(user.id, user.name)
>>> tuple(select)
('SELECT "a"."id", "a"."name" FROM "user" AS "a"', ())