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.