But can you still do things like slice(0,5)? Struggling to get that to work atm...
On Fri, Apr 27, 2018 at 2:48 PM, Simon King <si...@simonking.org.uk> wrote: > On Fri, Apr 27, 2018 at 12:57 PM, Jeremy Flowers > <jeremy.g.flow...@gmail.com> wrote: > > Right... > > Been trawling back thru this chain of exchanges.. > > Looking for this: > >> > >> At this point I would echo Mike's question: why can't you just use > >> "text()"? > > > > Just spotted another comment from Mike, that I've just fixed too... > >> > >> the literal() has to be against the regular value 1 and not the > string... > > > > > >> as a practical matter, this query is Oracle-specific in any > >> case, is there a reason you can't just use text() ? The reason > >> text() exists is for when one has the exact SQL they want already and > >> there is no need to work it into the expression language. > > > > > > Can I just put that into some sort of session execute? > > If there's a relevant example someone can point me to, it would help. > I'll > > have a dig around. > > > > There are a few examples of using text() with the ORM here: > > http://docs.sqlalchemy.org/en/latest/orm/tutorial.html# > using-textual-sql > > session.execute() behaves more like the Core-level > connection.execute(), which is described here: > > http://docs.sqlalchemy.org/en/latest/core/tutorial.html# > sqlexpression-text > > Simon > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to a topic in the > Google Groups "sqlalchemy" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/sqlalchemy/aWJT1VdY3LU/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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 https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.