TableCore
Sign in

Articles

SQL thinking, MongoDB running.

Practical writing for developers who know SQL and work with MongoDB — aggregation pipelines, joins, codegen and the workflows in between.

SQL to MongoDBMongoDB Compass SQL query: what works, what does notCompass has no SQL box. What its query bar takes instead, what the AI query bar costs you, and where MongoDB's official SQL access actually lives.TableCore Team · · 7 min read
CodegenMongoDB query to TypeScript: carrying a pipeline into the Node.js driverThe pipeline is portable; the types are not. Why aggregate() hands you an unchecked promise, and the three details that turn a working query into a wrong one.TableCore Team · · 7 min readSQL to MongoDBMongoDB WHERE IN: the SQL equivalent of $in and $ninIN survives the trip to MongoDB almost unchanged. NOT IN does not: the two disagree about a missing field, and a NULL in the list empties a SQL result entirely.TableCore Team · · 6 min readSQL to MongoDBHow to query MongoDB with SQLThree honest answers — translate the query, put a SQL layer in front, or learn the pipeline — and what each one is actually good at.TableCore Team · · 7 min readSQL to MongoDBMongoDB aggregation pipeline examples, with the SQL each one replacesEight pipelines covering filtering, grouping, joining, paging and counting — each next to the SQL statement it corresponds to.TableCore Team · · 8 min readSQL to MongoDBHow to write GROUP BY in MongoDB if you only know SQLGROUP BY is one line of SQL and a multi-stage aggregation pipeline in MongoDB. A walkthrough of how the two models map onto each other.TableCore Team · · 7 min readSQL to MongoDBMongoDB JOIN: the SQL equivalent of $lookupMongoDB has no JOIN keyword, but $lookup covers most relational joins. What translates cleanly, what does not, and how to reason about it.TableCore Team · · 9 min readCodegenFrom SQL query to MongoDB pipeline to C# codeA single query has three useful shapes: the SQL you think in, the pipeline MongoDB runs, and the driver code your application ships.TableCore Team · · 6 min read