issue_comments: 988461884

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/1304#issuecomment-988461884 https://api.github.com/repos/simonw/datasette/issues/1304 988461884 IC_kwDOBm6k_c466rs8 30934 2021-12-08T03:20:26Z 2021-12-08T03:20:26Z NONE

The easiest or most straightforward thing to do is to use named parameters like:

sql select * where key IN (:p1, :p2, :p3)

And simply construct the list of placeholders dynamically based on the number of values.

Doing this is possible with datasette if you forgo "canned queries" and just use the raw query endpoint and pass the query sql, along with p1, p2 ... in the request.

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