Method: Sequel::Access::DatasetMethods#case_expression_sql_append

Defined in:: lib/sequel/adapters/shared/access.rb

#case_expression_sql_append(sql, ce) ⇒ `Object`

Access doesn’t support CASE, so emulate it with nested IIF function calls.



104
105
106

# File 'lib/sequel/adapters/shared/access.rb', line 104

def case_expression_sql_append(sql, ce)
  literal_append(sql, ce.with_merged_expression.conditions.reverse.inject(ce.default){|exp,(cond,val)| Sequel::SQL::Function.new(:IIF, cond, val, exp)})
end