lucid_sql
Installation
Add the gem to your ‘Gemfile’:
gem 'lucid_sql'
Usage
Without Sequel gem
sql = LucidSQL::Repository.new('sql/*.sql')
sql.select_unpublished_products # sql/select_unpublished_products.sql
Interpolate trusted data for query reuse (see String#%).
sql.copy_from_stdin(table: 'products')
Does not support bind parameters.
With Sequel gem
sql = LucidSQL::SequelRepository.new('sql/*.sql')
Splat arguments are bind parameters (see Sequel.lit).
sql.copy_from('/path/to/copy_data/products', table: 'products')