SQL is near and dear to me and I can write it fast. Does anyone know if its possible to write an SQL query for a MongoDB; if so, how?
Short answer: No - with Metabase you can use Mentabase custom queries - or switch to native MongoDB queries (but I guess that’s what you’re trying to avoid).
If you search for MongoDB and SQL in here - you’ll quickly spot that e.g. some users tried using a translation layer like Metabase + MongoDB Connector for BI - but depending on complexity of your actual data and queries it looks like it’s an area where YMMV.