Hasura GraphQL Engine and SQL Server(github.com)

    with quotations as (
      select 'quotation' as type, created,
      row_to_json(blog_quotation) as row
      from blog_quotation
    ),
    blogmarks as (
      select 'blogmark' as type, created,
      row_to_json(blog_blogmark) as row
      from blog_blogmark
    ),
    combined as (
      select * from quotations
      union all
      select * from blogmarks
    )
    select * from combined order by created desc limit 100

    select
      blog_entry.id, title, slug, created,
      json_agg(json_build_object(blog_tag.id, blog_tag.tag))   
    from
      blog_entry
        join blog_entry_tags on blog_entry.id = blog_entry_tags.entry_id
        join blog_tag on blog_entry_tags.tag_id = blog_tag.id
    group by
      blog_entry.id
    order by
      blog_entry.created desc
    limit 10