Terrazin

Simple and comfortable, as possible, data structures parser in to SQL.

Describing sql with data structures like honeysql or ql in clojure.

Construct data structures inside Constructor instance.

Get result and access any returned data rails like syntax.

This was my first meeting with OOP... Now it's scary inside, but there is 0.0.4 will be soon that will be not so scary=))

Now? supports only Postgresql.

I tried to find something that will help me to create complex SQL queries, but there was only String and .erb... They didn't respond to my requirements=( In my vision data structures, especially in combination with objects(Constructor), more convinient way for representing complex SQL than String or ORM...
As for me, the right question is why only now? Why so late? Or i still blind...

Add this line to the Gemfile

gem 'terrazine', '0.0.3'

After server initialization set Terrazine.config. Now config accepts only :connection option. In the bright future will be added :adapter option support.
In rails you can set config with after_initialize and it will looks like:

# file config/application.rb
module Name
  class Application < Rails::Application
  # ....
    config.after_initialize do
      Terrazine.config connection: -> { ActiveRecord::Base.connection.raw_connection }
    end
  # ....
  end
end

• Describe whole data structure, or create Constructor instance and combine parts of data by it instance methods.
• Send result to Terrazine.send_request(structure||constructor, params = {})
• Rejoice at the ::Result

• Expand predicates syntax
• added support of multiple rows for VALUES
• ORDER structure
• UPDATE structure
• scary tests-_-

You can write me your suggestions for improving the syntax, wishes, things that you think are missing here.
My email, Ruby On Rails slack