noql
Converts SQL statements into MongoDB queries and pipelines
All Skills in This Repository (1)
Pure Emerald Level IndicatorsFrequently Asked Questions
FAQPage SchemaHow to install NoQL?โผ
Run `npx skills add synatic/noql --all -g -y` in your terminal to install this skill globally.
How to convert SQL to MongoDB queries?โผ
Pass any MySQL or PostgreSQL statement to the parseSQL method and it returns a MongoDB find query or aggregation pipeline ready to run with the MongoDB driver.
Does NoQL support joins and grouping?โผ
Yes. It supports inner, left, and full outer joins, GROUP BY aggregates, subqueries, window functions, and join hints like first, last, and unwind.
Which SQL dialects does NoQL support?โผ
NoQL supports both MySQL and PostgreSQL syntax, and generates queries compatible with MongoDB 3.6 or greater.
What SQL features are not supported by NoQL?โผ
Common table expressions, OVER clauses outside window functions, and some union variants are limited, but pivot, unpivot, and UNION ALL are supported.
Related Repositories in Data & Analytics
View All in Data & AnalyticsโPaddleOCR
Extract text, tables, and formulas from PDFs and images
Scrapling
Scrape any website and bypass anti-bot protection with AI
last30days-skill
Research any topic across Reddit, X, YouTube, and the web