search

simonw / sqlite-utils

Python CLI utility and library for manipulating SQLite databases
https://sqlite-utils.datasette.io
Apache License 2.0
1.66k stars 111 forks source link

Idea: `sqlite-utils create-table tablename --sql "select ..."` #481

Open simonw opened 2 years ago

simonw commented 2 years ago

Could offer syntactic sugar for:

create table foo as select * from bar
sqlite-utils create-table data.db foo --sql "select * from bar"

https://sqlite-utils.datasette.io/en/stable/cli-reference.html#create-table