Steampipe SQLite – Virtual tables translated for common APIs (opens in new tab)

This plays really well with datasette:

grab https://github.com/turbot/steampipe-plugin-hackernews/releas...

  datasette --load-extension steampipe_sqlite_hackernews.so 

and then in your browser:

  select
    *, 'https://news.ycombinator.com/item?id=' || id as link
  from
    hackernews_item
  where
    id = 38713046;