Hadouken - rapid JSON generator directly inside the PostgreSQL 9.3+

class MyJsonResponse < Hadouken::Json
  attribute :my_var, String # I'm using Virtus.model, you can pass your arguments like that

  def structure
    {
      # Static columns marked with leading underscore
      _title: "Some static title",
      _myVariable: my_var,

      users: array_of({
        companyName: '.company.name', # A name field from, the company (belongs_to association)
        id: 'id',
        fullName: 'name', # name - is a column name
        address: "COALESCE(NULLIF(users.address, ''), users.geolocation)",

        posts: array_of({
          id: 'id',
          title: 'title',
          fullText: 'description',
          isPublished: 'published',
        }, for: 'posts') # 'for' could be a relation or a string with relation name

      }, for: relation)
    }
  end
end

MyJsonResponse.call(relation: User.all, my_var: 'anything') # => JSON string

class Company
  has_many :users
end

class User
  belongs_to :company
  has_many :posts, -> { where(published: true) }
end

class Post
  belongs_to :user
end

class ApiController < ::ApplicationController
  def users_with_posts
    render json: {???}.as_json, status: :ok
  end
end