Hi all, I'm exploring extensions to Calcites parser and saw that the Babel parser impl has some nice things I want to work with, namely support for Spark-style LEFT_SEMI_JOINs syntax. Using this parser works for me, but I noticed that when using SqlToRelConverter, converting LEFT_SEMI_JOIN is not implemented. This seems strange to me, since there is both a JoinType.LEFT_SEMI_JOIN, and a RelJoinType.SEMI. I'm aware that I could always write the query using a different syntax (EXISTS, or IN), but was curious if there is a "Calcite way" of achieving my desired behavior before writing my own logic. Is there a way to convert queries with LEFT_SEMI_JOINs into a RelNode, and is this gap intentional?
Thanks, Logan