The Query Builder allows you to visually JOIN two tables.  Then choose options to customize the JOIN.  But it doesn't allow full free form customization, so we can't do a JOIN like this :

SELECT * FROM TABLE1 T1 LEFT JOIN TABLE2 T2 ON SUBSTRING(T1.KEY, 64, 3) = T2.KEY