In Snowflake, you can do something akin to an APPLY, but not. That, my friends, is a LATERAL join. According to Snowflake documentation, this type of join “allows an inline view to reference columns from the table expression that precedes the inline view.”
Yes, that’s gibberish. Let’s show what you’re doing.
I’m such an
APPLY apologist that the description made sense to me.