*I saw the following Q posted on SO:* Difference between SQLAlchemy Select and Query API <https://stackoverflow.com/questions/72828293/difference-between-sqlalchemy-select-and-query-api> Not sure if this has been asked before, but in the SQLAlchemy docs <https://docs.sqlalchemy.org/en/14/tutorial/index.html#unified-tutorial> they talk about introducing select() as part of the new 2.0 style for the ORM. Previously (1.x style), the query() method were used to fetch data. *What is the difference between these two?*
Is there any significant advantage of using one compared to other, for example, a performance boost? 2.0 API is still in active development yet it seems like their documentation is favoring the select API more than the "legacy" query API. Is this merely attempting to bridge the gap between the ORM and Core functionalities? *I attempted to answer with the following:* My Answer (Though I am not confident this is 100% correct) The biggest difference is how the select statement is constructed. The new method creates a select object <https://docs.sqlalchemy.org/en/14/core/selectable.html#sqlalchemy.sql.expression.select> which is more dynamic since it can be constructed from other select statements, without explicit subquery definition <https://docs.sqlalchemy.org/en/14/core/selectable.html#selectable-foundational-constructors> The outcome is more "native sql" construction of querying, as per the latest selectable API <https://docs.sqlalchemy.org/en/14/core/selectable.html#sqlalchemy.sql.expression.Select>. Queries can be defined and passed throughout statements in various functionalities such as where clauses, having, select_from, intersect, union, and so on. Performance wise, probably some slight benefit in python run time (compiling of query), but negligible compared to network latency + db work. *My question for you all:* Is my answer above correct? That creation of a select object is "the thing." -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/eda0b7be-e500-4a61-86ab-efa59797976an%40googlegroups.com.
