如何通过迭代列表来构建PyPika查询？

Question

是否可以使用PyPika使用列表来选择字段来构建SQL查询？尝试类似于下面的内容来构建SQL查询。

from pypika import Query, Table
customers = Table('data_table')
field_list = ['user', 'age']
sql = Query.from_(customers).select(field_list).where(
    (customers.start_time >= start_time) &
    (customers.end_time <= end_time) &
    (customers.pair == pair)
)

Answer 1

我认为这样做是可行的：

from pypika import Query, Table,Field
customers = Table('data_table')
field_list = [Field(c) for c in ['user', 'age']]
sql = Query.from_(customers).select(*field_list).where(
    (customers.start_time >= start_time) &
    (customers.end_time <= end_time) &
    (customers.pair == pair)
)

注意field_list与*；的解压缩。)