I wrote about Doctrine custom DQL functions https://emre.xyz/lets-write-a-custom-function-to-doctrine