Oh, man I got it. Cannot imagine what kind of an insight hit me when I figured it out! Here <https://gist.github.com/ojomio/d449abffe588a2abd32b> is a test case and final version of VALUES clause
Btw, why there is no _type_api mapping for a list() python type (https://github.com/zzzeek/sqlalchemy/blob/master/lib/sqlalchemy/sql/sqltypes.py#L1960) , at least as for version 1.0.9, which I use? We have to explicitly use `array` literal everywhere insted of just specifying python lists like [1,2,3] пятница, 20 ноября 2015 г., 0:30:15 UTC+5 пользователь Michael Bayer написал: > > well what is the ARRAY data you're passing into it? can you provide a > complete example? > > On 11/19/2015 02:04 PM, Юрий Пайков wrote: > > The problem is - I can't wrap my head round using it... Could you > > direct me to same compiled clause which uses bindparams? > > Or perhaps maybe to some documentation on SQLA internals, because it is > > quite difficult to track the whole query compilation process for me > > четверг, 19 ноября 2015 г., 21:14:59 UTC+5 пользователь Michael Bayer > > написал: > > > > > > > > you can try a bindparam(), sure. the original question, > everything > > under @compiles should return plain text, yes, those functions all > need > > to return text that is appended to the SQL statement. > > > > -- > > You received this message because you are subscribed to the Google > > Groups "sqlalchemy" group. > > To unsubscribe from this group and stop receiving emails from it, send > > an email to sqlalchemy+...@googlegroups.com <javascript:> > > <mailto:sqlalchemy+unsubscr...@googlegroups.com <javascript:>>. > > To post to this group, send email to sqlal...@googlegroups.com > <javascript:> > > <mailto:sqlal...@googlegroups.com <javascript:>>. > > Visit this group at http://groups.google.com/group/sqlalchemy. > > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.