search

sebastienros / yessql

A .NET document database working on any RDBMS
MIT License
1.22k stars 198 forks source link

JSON Querying Support #166

Open cocowalla opened 5 years ago

cocowalla commented 5 years ago

Some database engines have built-in support for querying JSON types, such as Postgres (this is how Marten works) and (to a more limited extent) Microsoft SQL Server.

For databases that support this, it would be great to be able to query documents in this way. This would also mean that you wouldn't have to create indexes for every possible way you want to query your data up-front.

CoskunSunali commented 5 years ago

@cocowalla MySQL supports native json functions too. https://dev.mysql.com/doc/refman/8.0/en/json.html

Marten is a great library. I wish it worked with Microsoft SQL Server.

HengzheLi commented 3 years ago

Vote for JSON querying feature