Support MongoDB

[kaaax0815]

I use MongoDB alot for its simplicity.
Prisma is good at handling it so why shouldnt drizzle

[dankochetov]

Currently it's out of scope for this project, since we focus on SQL databases. If we were to build an ORM for MongoDB, it would be a different library.

[idolize]

Thank you! I appreciate when a library does one thing well, instead of trying to be everything to everybody.

I love how this library is already very close to the SQL syntax, and I suspect if you were to try to abstract it to also make sense for a NoSQL DB like Mongo then we'd lose that aspect. So, anyway, thank you!

[alexandrutocar]

Currently it's out of scope for this project, since we focus on SQL databases. If we were to build an ORM for MongoDB, it would be a different library.

Just to add a few more arguments against the idea (for anyone passing by).

• It is impossible to integrate no-sql query language into a totally different paradigm of sql. Learn one or the other.
• Standalone MongoDB driver already does a great job at strongly typing queries and data.
• If you use MongoDB, then you have to stay in the paradigm of Document Databases, with its unique set of features and design flaws:
  • You do not care of columns and raws.
  • You allow for nested documents, arrays, object-id.
  • You allow duplicate entries for the sake of replication.
  • You utilize aggregation with its, grouping and other transformations.
  • You index your data by nested keys, write expiration indexes.
  • You use different collection types (timeseries, set-size, etc.).

For MongoDB you have: MongoDB Driver (best choice). You can also use Mongoose or Prisma ORM, but they provide degraded perfomance.