Order_ functions : How to use litteral SQL expressiosns?


#1

Hello.

I’m still learning the pyton-sql library, but I see that a range of PSQL functions are not implemented.
I understand that order_ functions ’ return are used to construct an ORDERBY query.
Is there a way to express the query (or in this case a part of the query) literally ? I mean using a string of native psql code ?

Thank you for your help.


(Cédric Krier) #2

No it is not supported for security reason (e.g. SQL injection).

python-sql supports only standard SQL functions. It will be odd that you can not find what you need.