🪲 JOIN on literals not working

[joocer]

SELECT * FROM $planets AS p JOIN $planets AS g ON p.id = g.id AND g.name = 'Earth';