How do I pass arguments to SQL functions?

[asultanpur]

I want to pass the value of a var to my SQL function.

(sql/sql (sql/select db [:*] (sql/from `(:my-func ~arg))))

But I get an error:

ExceptionInfo Can't parse FROM form.  clojure.core/ex-info (core.clj:4739)

However I'm able to pass string arguments:

=> (sql/sql (sql/select db [:*] (sql/from '(:my-func "abc"))))
["SELECT * FROM \"my_func\"(?)" "abc"]

I want to pass the value of arg instead of plain string. How do I do that?

[r0man]

It might be that a function in the from clause is not yet supported. I am AWFK at the moment. PR welcome!

…

On Tue, Jun 26, 2018, 16:03 Avinash Sultanpur ***@***.***> wrote: I want to pass the value of a var to my SQL function. (sql/sql (sql/select db [:*] (sql/from `(:my-func ~arg)))) But I get an error: ExceptionInfo Can't parse FROM form. clojure.core/ex-info (core.clj:4739) However I'm able to pass string arguments: => (sql/sql (sql/select db [:*] (sql/from '(:my-func "abc")))) ["SELECT * FROM \"my_func\"(?)" "abc"] I want to pass the value of arg instead of plain string. How do I do that? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#113>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AABUPs_AzMy45OkxMKtEodjkxjpy6hhnks5uAj9JgaJpZM4U4Aig> .