Hello DOJO

Is it possible with gqi to join 2 tables by using a like clause ?

for example:
if the column in A is '448959-33445-35'. Then the join would match if column in B is either: '448959-33445-35.10/2024', '448959-33445-35.11/2024', or just '448959-33445-35'

I know it's possible with SQL like this :

SELECT *
FROM TABLE a
JOIN TABLE b ON b.column LIKE 'a.column +'%'

It would be very helpfull to know how to achieve this 🙂