SQL-to-NOSQL
As the name suggests, sql-to-nosql lets you run SQL scripts on your NoSQL database.
Status
The project is under active development and is not yet ready to use in production. I'm aiming to launch v-1.0 by November 2023 with some of the most common sql operations. 🤞
Installation
npm insall sql-to-nosql
# or
yarn add sql-to-nosql
# or
pnpm add sql-to-nosql
Usage
import { SqlToNoSql } from "sql-to-nosql";
const runner = new SqlToNoSql({
srcDBtype: "postgresql",
destDBtype: "mongodb",
connection: "YOUR_DEST_DB_CONNECTION_STRING",
});
const resp = await runner.run(
"select * from users where email = devarifhossain@gmail.com",
);
console.log(resp);
/** ☝️ [{
_id: new ObjectId("622f07d56852c662cb8b953b"),
role: 'admin',
name: 'Arif Hossain',
email: 'devarifhossain@gmail.com',
__v: 0
}]*/
Roadmap
- [ ] Database
- [x] MongoDB
- [ ] Commands
- [x] SELECT
- [ ] INSERT
- [ ] DELETE
- [ ] UPDATE
- [ ] Clauses
- [x] WHERE
- [x] ORDER BY
- [x] LIMIT
- [x] OFFSET
- [ ] GROUP BY
- [ ] HAVING
- [ ] JOIN
- [ ] UNION
- [ ] INTERSECT
- [ ] EXCEPT
- [ ] Functions
- [ ] COUNT
- [ ] SUM
- [ ] AVG
- [ ] MIN
- [ ] MAX
- [ ] Operators
- [x] =
- [x] !=
- [x] >
- [x] <
- [x] > =
- [x] <=
- [ ] AND
- [ ] OR
- [ ] NOT
- [ ] IN
- [ ] BETWEEN
- [ ] LIKE
- [ ] IS NULL
- [ ] IS NOT NULL
- [ ] Typescript Support
Contributing
Read the contributing guide to learn how you can contribute to this project.