issues: 480961330

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason performed_via_github_app reactions draft state_reason
480961330 MDU6SXNzdWU0ODA5NjEzMzA= 54 Ability to list views, and to access db["view_name"].rows / rows_where / etc 20264 closed 0     5 2019-08-15T02:00:28Z 2019-08-23T12:41:09Z 2019-08-23T12:20:15Z NONE  

The docs show me how to create a view via db.create_view() but I can't seem to get back to that view post-creation; if I query it as a table it returns None, and it doesn't appear in the table listing, even though querying the view works fine from inside the sqlite3 command-line.

It'd be great to have the view as a pseudo-table, or if the python/sqlite3 module makes that hard to pull off (I couldn't figure it out), to have that edge-case documented next to the db.create_view() docs.

 140912432 issue     
{
    "url": "https://api.github.com/repos/simonw/sqlite-utils/issues/54/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   completed

Links from other tables