No, you'll need to convert that to the equivalent SQL. On Fri, Apr 27, 2018 at 3:14 PM, Jeremy Flowers <[email protected]> wrote: > 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 <[email protected]> wrote: >> >> On Fri, Apr 27, 2018 at 12:57 PM, Jeremy Flowers >> <[email protected]> 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 >> [email protected]. >> To post to this group, send email to [email protected]. >> 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 [email protected]. > To post to this group, send email to [email protected]. > 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
