Versatile Database Access
The Doctrine DBAL (database abstraction layer) allows TYPO3 to interact with the databases without needing to know specific details of the underlying database system/engine. Developers use a unified interface to perform database operations, regardless of the actual database being used.
TYPO3’s ExpressionBuilder class is one of the components that is responsible for dynamically creating SQL query parts. The class is based on Doctrine DBAL’s ExpressionBuilder and only uses a subset of all available expressions.
In TYPO3 v13.1, additional expression methods are now available to build advanced database queries. This includes concat(), castVarchar(), castInt(), leftPad(), rightPad(), and more.
For a list of the new expressions and how to use them, see the changelog entry.