ActiveRecord SQL logger helper, shows only INSERT/UPDATE/DELETE

example_spec.rb

it "does something" do
  log_sql do
    request
    expect(create_call).to_not raise_exception
  end
end

log_sql.rb

def log_sql
  subscriber = ActiveSupport::Notifications.subscribe("sql.active_record") do |event|
    payload = event.payload[:sql]
    next if payload.match?(/^(SELECT|SET|SHOW|BEGIN|COMMIT|ROLLBACK|RELEASE|SAVEPOINT)/)

    event.payload[:type_casted_binds].each_with_index do |bind, index|
      payload = payload.gsub("$#{index + 1}", "'#{bind}'")
    end
    puts payload
  end
  yield
  ActiveSupport::Notifications.unsubscribe(subscriber)
end