issue_comments: 552252074

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/620#issuecomment-552252074 https://api.github.com/repos/simonw/datasette/issues/620 552252074 MDEyOklzc3VlQ29tbWVudDU1MjI1MjA3NA== 9599 2019-11-11T00:28:28Z 2019-11-11T00:30:53Z OWNER

So for foreign key definitions it could look like this:

/db/table?_fk.article_id=articles.id

Or for columns and table names that themselves contain dots it could be:

/db/table?_fk.article_id={"table":"articles","column":"id"}

The value (before the =) is unambiguous -it's ?fk.XXX where XXX could be a column name that includes periods without breaking anything.

Added bonus: if you're referencing another table's single primary key you can omit the .id entirely (since it can be automatically detected) - so you could do ?_fk.article_id=articles.

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