How to use MySQL functions in DAL in shopware6?

[abinjohnedamana]

How to use MySQL functions in DAL?

For example how to do the following search in DAL?

SELECT * FROM customer_address WHERE LCASE(first_name)='abin'