LANGUAGE » PYTHON » PACKAGE

Pypika

Last updated:
Reference:github.com

Install ​

bash
pip install wheel
pip install pypika

Usage ​

python
from pypika import Query

## Select
Query.from_('mytable') \
    .select('field1', 'field2') \
    .get_sql(quote_char=None)

## Insert
Query.into('mytable') \
    .columns('field1', 'field2') \
    .insert('hello', 8)

## Update
Query.update('mytable') \
    .set('field1', 'world') \
    .set('field2', 12)