issue_comments: 1021860694

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/datasette/issues/1613#issuecomment-1021860694 https://api.github.com/repos/simonw/datasette/issues/1613 1021860694 IC_kwDOBm6k_c486FtW 9599 2022-01-26T04:57:53Z 2022-01-26T04:57:53Z OWNER

The existing flow where you can apply filters to a table and then click "View and edit SQL" to see the query is a good starting point.

Group by queries are both crucially important and difficult to assemble for beginners. Providing a way to see the query that was used by a facet (since facets are really just group-by-counts) would be very useful, which could come out of this:

  • 1080

 
{
    "total_count": 1,
    "+1": 1,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 1114628238