{"repo":"hoangsonww/SQL-Mongo-Query-Converter","free":true,"listed":false,"github":"https://github.com/hoangsonww/SQL-Mongo-Query-Converter","clone":"git clone https://github.com/hoangsonww/SQL-Mongo-Query-Converter.git","description":"🛠️ SQLMongo - A PyPI package for converting SQL queries to MongoDB queries and vice versa. Effortlessly translate between relational and NoSQL query formats for seamless database interoperability.","language":"Python","stars":25,"topics":["aggregation","aggregator","database","mongo","mongo-aggregation","mongo-aggregation-framework","mongodb","mysql","postgresql","pypi"],"license":"MIT","category":"databases-storage","readme_excerpt":"SQL-Mongo Converter - A Lightweight SQL to MongoDB (and Vice Versa) Query Converter 🍃 SQL-Mongo Converter is a lightweight Python library for converting SQL queries into MongoDB query dictionaries and converting MongoDB query dictionaries into SQL statements. It is designed for developers who need to quickly migrate or prototype between SQL-based and MongoDB-based data models without the overhead of a full ORM. Currently live on PyPI: https://pypi.org/project/sql-mongo-converter/ --- Table of Contents - Features - Installation - Usage - Converting SQL to MongoDB - Converting MongoDB to SQL - API Reference - Testing - Building & Publishing - Contributing - License - Final Remarks --- Features - Comprehensive SQL to MongoDB Conversion: - SELECT queries : Simple and complex queries with WHERE, ORDER BY, GROUP BY, HAVING, LIMIT, OFFSET - INSERT operations : Single and bulk inserts with column specifications - UPDATE operations : Targeted updates with WHERE clauses - DELETE operations : Conditional and bulk deletions - JOIN operations : INNER JOIN and LEFT JOIN converted to MongoDB $lookup aggregation - CREATE operations : TABLE and INDEX creation with schema validation - DROP operations : TABLE and INDEX dropping - DISTINCT queries : Single and multiple field distinct operations - Aggregation functions : COUNT, SUM, AVG, MIN, MAX with GROUP BY/HAVING - Advanced WHERE operators : BETWEEN, LIKE (with wildcards), IN, NOT IN, IS NULL, IS NOT NULL, OR, NOT - Bidirectional MongoDB to ","default_branch":null,"files":null,"tree":[],"storefront":"/r/hoangsonww","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/hoangsonww/SQL-Mongo-Query-Converter/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}