issue_comments: 1172902594

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/sqlite-utils/issues/449#issuecomment-1172902594 https://api.github.com/repos/simonw/sqlite-utils/issues/449 1172902594 IC_kwDOCGYnMM5F6RLC 9599 2022-07-02T13:55:51Z 2022-07-02T13:55:51Z OWNER

I like the idea of this as a feature - design could look like this:

db["my_table"].duplicate("new_table")

Then for the CLI tool:

sqlite-utils duplicate data.db my_table new_table

Additional features that might be useful:

  • Duplicate across connection aliases - so you can copy a table to another database using the duplicate method or command
  • Ability to execute an arbitrary SQL query and save the results to a new table - basically a wrapper around CREATE TABLE t AS SELECT ..., again with alias support for copying to another database
 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 1279863844