VALUES clause in SQLAlchemy

by

This is now natively available in SQLAlchemy.

Your example would be written as:

from sqlalchemy import select, column, Integer
from sqlalchemy.sql import Values

select(Values(column('Number', Integer), name="sq").data([(1,), (2,), (3,)]))

There doesn’t seem to be any documentation on this, but you can have a look at the test cases https://github.com/sqlalchemy/sqlalchemy/blob/master/test/sql/test_values.py

More Related Contents:

  1. How to execute raw SQL in Flask-SQLAlchemy app
  2. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  3. sqlalchemy: how to join several tables by one query?
  4. Python, SQLAlchemy pass parameters in connection.execute
  5. Complex foreign key constraint in SQLAlchemy
  6. How to get rows which match a list of 3-tuples conditions with SQLAlchemy
  7. SQLAlchemy: how to filter date field?
  8. How to execute “left outer join” in SqlAlchemy
  9. Getting random row through SQLAlchemy
  10. Select NULL Values in SQLAlchemy
  11. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  12. SQLAlchemy Obtain Primary Key With Autoincrement Before Commit
  13. flask sqlalchemy query with keyword as variable
  14. SQLAlchemy IN clause
  15. Flask SQLAlchemy query, specify column names
  16. How can I bind a list to a parameter in a custom query in SQLAlchemy?
  17. How to disable SQLAlchemy caching?
  18. Using a WHERE ___ IN ___ statement
  19. Django: Adding “NULLS LAST” to query
  20. sqlalchemy unique across multiple columns
  21. return SQL table as JSON in python
  22. Multi-threaded use of SQLAlchemy
  23. How to discover table properties from SQLAlchemy mapped object
  24. How to delete a table in SQLAlchemy?
  25. How to quote a string value explicitly (Python DB API/Psycopg2)
  26. Trigger in sqlachemy
  27. ImportError: cannot import name ‘_ColumnEntity’ from ‘sqlalchemy.orm.query’
  28. How to prevent UUID primary key for new SQLAlchemy objects being created with the same value
  29. Pandas analogue to SQL MINUS / EXCEPT operator, using multiple columns
  30. SQLALchemy dynamic filter_by

Leave a Comment