Insert dictionary

[jly36963]

I wish their was a built-in way to insert dictionaries.

This is what I wish existed

from pypika import Query, Table

users = Table('users')

Query.into(users).insert_dict({
    'first_name': 'John',
    'last_name': 'Doe',
})

This is what I'm currently doing:

@classmethod
def insert_dict(self, table, d): return (
    self
    .into(table)
    .columns(*d.keys())
    .insert(*d.values())
)

Query.insert_dict = insert_dict

Query.insert_dict(users, {
    'first_name': 'John',
    'last_name': 'Doe',
})