sql 2022-03-06 | Slack Archive

manas_marthi14:03:37

Hi All, when using next.jdbc and, when I run (sql/find-by-keys conn :Forty_char_long_table_anem {:id id})) and then run (println (keys record)) , each key is too long tablename/field_name . Is there a way to replace table name with table alias like tb

lukasz16:03:55

You're looking for this I think: https://github.com/seancorfield/next-jdbc/blob/develop/doc/result-set-builders.md

seancorfield18:03:31

I recommend you get used to qualified key names -- they are *idiomatic* in Clojure.

manas_marthi03:03:02

Yes, agreed. I want qualified column names. But I want table alias, just like we have namespace alias in require

manas_marthi03:03:19

pls advise if it is possible

seancorfield06:03:57

No, it is not possible.

manas_marthi08:03:41

Noted. thaank you

2022-03-06

Channels