DDL

CREATE TABLE AS SELECT

qb.create_table_as(
   qb.select('*').from_table('users').where(eq('status', 'active')),
   'active_users',
)
# CREATE TABLE active_users AS SELECT * FROM users WHERE status = %(p1)s
# {'p1': 'active'}

See test_create_table

CREATE VIEW

(
    qb
    .create_view(
        qb.select('*').from_table('users'),
        'active_users',
    )
).get_sql()
# CREATE VIEW active_users AS SELECT * FROM users

(
    qb
    .create_view(
        qb.select('*').from_table('users'),
        'active_users',
        if_not_exists=True
    )
).get_sql()
# CREATE VIEW IF NOT EXISTS active_users AS SELECT * FROM users

(
    qb
    .create_view(
        qb.select('*').from_table('users'),
        'active_users',
        if_not_exists=True, # if_not_exists ignored
        or_replace=True     # or_replace has a higher priority
    )
).get_sql()
# CREATE OR REPLACE VIEW active_users AS SELECT * FROM users

(
    qb
    .create_view(
        qb.select('*').from_table('users'),
        'active_users',
        'analytics'
    )
).get_sql()
# CREATE VIEW analytics.active_users AS SELECT * FROM users

DROP TABLE

qb.drop().table('events')                          # DROP TABLE events
qb.drop().table('events', 'game', if_exists=True)  # DROP TABLE IF EXISTS game.events

DROP VIEW

drop().view('events')                             # DROP VIEW events
qb.drop().view('events', 'game', if_exists=True)  # DROP VIEW IF EXISTS game.events

See test_drop_table.py