That's a great question!
There is great interest in supporting multiple kinds of databases and this is something we will actively work on in the coming months.
SQL is a great general purpose data store, but there are certainly cases where you need a more specialised database. In Prisma we introduced some API changes to simplify working with nested data structures. An obvious next step is to use MongoDB for documents while keeping SQL for relational data.