module Sequel::SqlAnywhere::DatasetMethods

    # File lib/sequel/adapters/shared/sqlanywhere.rb
302 def complex_expression_sql_append(sql, op, args)
303   case op
304   when :'||'
305     super(sql, :+, args)
306   when :<<, :>>
307     complex_expression_emulate_append(sql, op, args)
308   when :LIKE, :"NOT LIKE"
309     sql << '('
310     literal_append(sql, args[0])
311     sql << (op == :LIKE ? ' REGEXP ' : ' NOT REGEXP ')
312     pattern = String.new
313     last_c = ''
314     args[1].each_char do |c|
315       if  c == '_' and not pattern.end_with?('\\') and last_c != '\\'
316         pattern << '.'
317       elsif c == '%' and not pattern.end_with?('\\') and last_c != '\\'
318         pattern << '.*'
319       elsif c == '[' and not pattern.end_with?('\\') and last_c != '\\'
320         pattern << '\['
321       elsif c == ']' and not pattern.end_with?('\\') and last_c != '\\'
322         pattern << '\]'
323       elsif c == '*' and not pattern.end_with?('\\') and last_c != '\\'
324         pattern << '\*'
325       elsif c == '?' and not pattern.end_with?('\\') and last_c != '\\'
326         pattern << '\?'
327       else
328         pattern << c
329       end
330       if c == '\\' and last_c == '\\'
331         last_c = ''
332       else
333         last_c = c
334       end
335     end
336     literal_append(sql, pattern)
337     sql << " ESCAPE "
338     literal_append(sql, "\\")
339     sql << ')'
340   when :ILIKE, :"NOT ILIKE"
341     super(sql, (op == :ILIKE ? :LIKE : :"NOT LIKE"), args)
342   when :extract
343     sql << 'datepart('
344     literal_append(sql, args[0])
345     sql << ','
346     literal_append(sql, args[1])
347     sql << ')'
348   else
349     super
350   end
351 end

    # File lib/sequel/adapters/shared/sqlanywhere.rb
359 def constant_sql_append(sql, constant)
360   case constant
361   when :CURRENT_DATE
362     sql << 'today()'
363   when :CURRENT_TIMESTAMP, :CURRENT_TIME
364     sql << 'now()'
365   else
366     super
367   end
368 end

    # File lib/sequel/adapters/shared/sqlanywhere.rb
250 def convert_smallint_to_bool
251   opts.has_key?(:convert_smallint_to_bool) ? opts[:convert_smallint_to_bool] : db.convert_smallint_to_bool
252 end

    # File lib/sequel/adapters/shared/sqlanywhere.rb
293 def cross_apply(table)
294   join_table(:cross_apply, table)
295 end

    # File lib/sequel/adapters/shared/sqlanywhere.rb
354 def escape_like(string)
355   string.gsub(/[\\%_\[]/){|m| "\\#{m}"}
356 end

    # File lib/sequel/adapters/shared/sqlanywhere.rb
371 def into(table)
372   clone(:into => table)
373 end

    # File lib/sequel/adapters/shared/sqlanywhere.rb
298 def recursive_cte_requires_column_aliases?
299   true
300 end

    # File lib/sequel/adapters/shared/sqlanywhere.rb
259 def supports_cte?(type=:select)
260   type == :select
261 end

    # File lib/sequel/adapters/shared/sqlanywhere.rb
264 def supports_grouping_sets?
265   true
266 end

    # File lib/sequel/adapters/shared/sqlanywhere.rb
276 def supports_is_true?
277   false
278 end

    # File lib/sequel/adapters/shared/sqlanywhere.rb
280 def supports_join_using?
281   false
282 end

    # File lib/sequel/adapters/shared/sqlanywhere.rb
268 def supports_multiple_column_in?
269   false
270 end

    # File lib/sequel/adapters/shared/sqlanywhere.rb
272 def supports_where_true?
273   false
274 end

    # File lib/sequel/adapters/shared/sqlanywhere.rb
284 def supports_window_clause?
285   true
286 end

    # File lib/sequel/adapters/shared/sqlanywhere.rb
288 def supports_window_functions?
289   true
290 end

    # File lib/sequel/adapters/shared/sqlanywhere.rb
255 def with_convert_smallint_to_bool(v)
256   clone(:convert_smallint_to_bool=>v)
257 end