fukamachi/sxql

No way to pass in a fully capitalized column name

ahungry opened this issue · 2 comments

A mixed case column or table name is usable with the pipes :|someThing|, will translate to "someThing" (using postgres), however just as :someThing is being converted to :SOMETHING by common lisp, which is then downcased by sxql to :something - how do we work with a column that is in all caps? (db column SOMETHING)?

The problem code is in operator.lisp and is as such:

             (let ((name (symbol-name object))
                   (string-fn (if (has-lower-case-letters-p object) ;; Only downcase all caps                                             
                                  #'string
                                  #'string-downcase)))

A temporary/interim solution (as long as your table + column aren't both all upcased) is to use table.CAPCOLUMN