Re: [sqlalchemy] Create ad hoc custom function

2019-07-15 Thread Mike Bayer
On Mon, Jul 15, 2019, at 11:16 AM, Ľuboš Katrinec wrote: > Thanks Mike for your explanation. It totally makes sense. I have not realize > that at all. > > Just for the record I am trying to follow my ETL process idea to allow > maximum flexibility to user so he can construct and shape data by

Re: [sqlalchemy] Create ad hoc custom function

2019-07-15 Thread Ľuboš Katrinec
Thanks Mike for your explanation. It totally makes sense. I have not realize that at all. Just for the record I am trying to follow my ETL process idea to allow maximum flexibility to user so he can construct and shape data by using SQL commands from JSON/CSV data produced (EXTRACT) by any kind

Re: [sqlalchemy] Create ad hoc custom function

2019-07-15 Thread Mike Bayer
On Mon, Jul 15, 2019, at 10:14 AM, Ľuboš Katrinec wrote: > I am looking for creating custom Python callable function that would be use > in raw SQL queries, very same to Connection.create_function() > which is > perfectly

[sqlalchemy] Create ad hoc custom function

2019-07-15 Thread Ľuboš Katrinec
I am looking for creating custom Python callable function that would be use in raw SQL queries, very same to Connection.create_function() which is perfectly working as I intend. I would like to be able to do it in SQLAlchemy