ActiveRecord supports lots of stuff through arel (https://github.com/rails/arel).
Are you sure you understood how to use the full functionality? What was missing (besides CTEs)?
Are you sure you understood how to use the full functionality? What was missing (besides CTEs)?
for example, last week I wanted to a bulk INSERT. maybe arel can do this (though I highly suspect it cannot since this isn't a part of relational algebra at all), but that's kind of worthless if i can't find any evidence of how to do it without reading the arel source.