i rarely ever use exists and prefer to do left joins or left semi joins (in spark)

i'm not exactly sure what you're asking though, in terms of sql generation, it's not difficult for me because i just take in sql and output sql from the ast