python - 将原始 SQL 转换为 SQLAlchemy 查询

Question

SELECT * 
FROM product_stocks 
WHERE detected_date = (
                         SELECT MAX(detected_date) 
                         FROM product_stocks 
                         WHERE id = 18865
                      ) 
      AND id = 18865;

将其转换为 SQLAlchemy 查询字符串时遇到很多麻烦。什么是最有效的方法？

Answer 1

您可以使用 from_statement 执行原始 SQL 查询并在 SQL-Alchemy 对象中获取它。当编写纯 SQL 比编写 SQLAlchemy 语法更容易时，这会有所帮助。

Session.query(YourClass).from_statement(text('''SELECT * FROM product_stocks 
WHERE detected_date = (SELECT MAX(detected_date) FROM product_stocks WHERE id = 18865)
AND id = 18865;''')).all()