DocumentDB 0.114 (MongoDB 7.0)

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select documentdb_api.binary_version() documentdb, version() postgres;

documentdb
postgres

0.114.0
PostgreSQL 18.6 (Debian 18.6-1.pgdg13+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit

SELECT 1

db.orders.insertMany([
  { _id: 1, customer: 'Ada',   total: 42 },
  { _id: 2, customer: 'Grace', total: 17.5 }
])
{ acknowledged: true, insertedIds: { '0': 1, '1': 2 } }

db.orders.find({ total: { $gt: 20 } })
[ { _id: 1, customer: 'Ada', total: 42 } ]

set documentdb_core.bsonUseEJson = on;
select document from collection('test','orders')

SET

document

{ "_id" : { "$numberInt" : "1" }, "customer" : "Ada", "total" : { "$numberInt" : "42" } }

{ "_id" : { "$numberInt" : "2" }, "customer" : "Grace", "total" : { "$numberDouble" : "17.5" } }

SELECT 2