relation-example.rb

class Jobs < ROM::Relation[:sql]
  schema(:jobs) do
    # ...

    associations do
      belongs_to :team
      belongs_to :template
      belongs_to :address
      belongs_to :client
    end
  end


  view(:index) do
    schema do
      append(
        relations[:references][:code].as(:type_code),
        relations[:teams][:name].as(:team_name),
        relations[:templates][:name].as(:template_name),
        relations[:addresses][:formatted].as(:formatted_address),
        relations[:clients][:name].as(:client_name)
      ).qualified
    end

    relation do |tenant_id|
      where(self[:tenant_id].qualified.is(tenant_id))
        .left_join(teams)
        .left_join(templates)
        .left_join(addresses)
        .left_join(clients)
      end
    end
  end
end