Issue Feature Closed

#103309Add more expression methods to ExpressionBuilder

Stefan Bürk 03/06/24, 16:08 updated 07/09/24, 15:33

Description

The ExpressionBuilder provides methods to build
database query expression parts for all supported
database vendors. A relativly conservative set has
been provided since a couple of TYPO3 and Doctrine
DBAL versions.

Additional expression methods should be added to
the ExpressionBuilder to pave the way for using
Common Table Expressions along with a to implement
CTE Builder API.

Following expressions should be implemented in a
cross database compatible way:

  • CONCAT
  • RIGHT
  • REPEAT
  • SPACE
  • LPAD
  • RPAD

where even more expression may be added at a later
point.

Reviews 4