No way to pass in a fully capitalized column name
ahungry opened this issue · 2 comments
ahungry commented
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
)?
ahungry commented
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)))
ahungry commented
A temporary/interim solution (as long as your table + column aren't both all upcased) is to use table.CAPCOLUMN