Use builder pattern to create ad-hoc SQL queries that aren't tied to models but return read-only plain Ruby objects.

A Ruby client for sqlcached

Use ActiveRecord to execute SQL against any DB to export CSV

The SQLite3 adapter in Rails 4 doesn't support JSON columns. This gem adds it via a railtie and a series of hacks.

No more '...sqlite_master...' queries in your log when using sqlite

Fork from ankane! Explore your data with SQL. Easily create charts and dashboards, and share them with your team.

SqlLoader allows you to keep your plain SQL queries as files instead of mixing them in your ActiveRecord models.

ActiveRecord extension that provides large performance improvements when you need large sets of read-only data and do not need the magic of ActiveRecord.

Query assertions and SQL matchers for RSpec.

This gem will help setup partitioning on a table, based on its `timestamp` column. Once you have a table that is partitioned based on a timestamp, you will likely need to regularly add new partitions into the future, and drop older partitions to free up space. This gem can help ca...

Provide #pluck_by_sql for Rails ActiveRecord models

A Ruby on Rails gem that analyzes SQL queries and suggests optimizations like missing indexes, inefficient sorts, and risky joins.

Do you use ActiveRecord::Connection.execute for speed sometimes? Does it bother you that the results are not mapped to your schema and type-cast as ActiveRecord would? Well that's what SQLRecord does.

With SQLreport you can manage query results and convert things.

SQLRunner allows you to load your queries out of SQL files, without using ORMs.

Debug SQL statements in ActiveRecord by displaying warnings on bad queries.

A gem that allows for simple SQL-based search and sort functionality

Sequence number generation in Rails

The author was too lazy to write a description

Retrieve SQL values using Active Record query interface but without instantiation of AR-objects