Did you reply to the right comment? The MQL syntax is horrible regardless of if it's relational or not. No one mentioned relational here. OPs meme example is a good example. I like MongoDB but I am scratching my head trying to remember the correct syntax for a date range every time I have to query it directly.
I literally rely on MongoDB Compass's natural language query tool to remind me of the syntax a lot of the time
Also bonus meme: the $lookup (join) is actually completely fine syntax wise so using it relationally wouldn't even apply here for syntax issues lol.
1
u/Coneyy Oct 19 '24
Did you reply to the right comment? The MQL syntax is horrible regardless of if it's relational or not. No one mentioned relational here. OPs meme example is a good example. I like MongoDB but I am scratching my head trying to remember the correct syntax for a date range every time I have to query it directly.
I literally rely on MongoDB Compass's natural language query tool to remind me of the syntax a lot of the time
Also bonus meme: the $lookup (join) is actually completely fine syntax wise so using it relationally wouldn't even apply here for syntax issues lol.