We tried with ChatGPT, if you throw enough context(Database Schema) to it, it will be able to find the relationship in the tables and generate the join correctly. And for date format, yeah, if you don't specify it, you won't get what you want in some cases.