database_dsl.rb

select [user_id, sum(payout),sum(fee).as(fee)], from: :transactions do
  join :users do
    users :id
    transactions :user_id
  end
  groupby :user_id
  where { user_id [1,2,3] }
  where { fee > 40 }
  order "sum(payout)", :desc
end

# Thinking of building a readable alternative for AREL.
# Must have feature is to make it composable in a similar way but
# Avoid a pit-fall of the over-complicated syntax.
# I haven't fininshed with the final version of the syntax yet,
# But once it's done, that's a fairly straightforward to make it work.
# also stumble across a similar project (10 year old!)  
# https://github.com/semenov/boroda
# but it lack composablity and syntax could have been better.
#
# one more thing from my experience:
# in 99.9% of complicated queries, it's all about producing select statements for 
# a reporting purposes.