Discuss – SQLAlchemy SQLAlchemy is a popular SQL toolkit and Object Relational Mapper. It is written in Python and gives full power and flexibility of SQL to an application developer. It is an open source and cross-platform software released under MIT license. SQLAlchemy is famous for its object-relational mapper (ORM), using which classes can be […]
Author Archives: user
SQLAlchemy Core – Using Conjunctions Conjunctions are functions in SQLAlchemy module that implement relational operators used in WHERE clause of SQL expressions. The operators AND, OR, NOT, etc., are used to form a compound expression combining two individual logical expressions. A simple example of using AND in SELECT statement is as follows − SELECT * […]
SQLAlchemy Core – Using Set Operations In the last chapter, we have learnt about various functions such as max(), min(), count(), etc., here, we will learn about set operations and their uses. Set operations such as UNION and INTERSECT are supported by standard SQL and most of its dialect. SQLAlchemy implements them with the help […]