{"id":43933,"library":"sql-promise","title":"sql-promise","description":"A minimal SQL helper library that wraps common SQL databases with Promise-based APIs. Version 0.0.19 is stable but marked as 'designing' in development status, suggesting early-stage or experimental maturity. It simplifies SQL CRUD operations by returning Promises, enabling async/await patterns. The library lacks broad adoption and active maintenance cadence is unclear. Its key differentiator is a lightweight abstraction over multiple SQL backends, but it does not support modern TypeScript types or streaming.","status":"deprecated","version":"0.0.19","language":"javascript","source_language":"en","source_url":"https://github.com/codenautas/sql-promise","tags":["javascript"],"install":[{"cmd":"npm install sql-promise","lang":"bash","label":"npm"},{"cmd":"yarn add sql-promise","lang":"bash","label":"yarn"},{"cmd":"pnpm add sql-promise","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[{"note":"This package uses CommonJS and does not ship ESM. Named ES imports will not work.","wrong":"import SQLPromise from 'sql-promise'","symbol":"SQLPromise","correct":"const SQLPromise = require('sql-promise')"},{"note":"Ensure you destructure after require. This is not available as a named ES import.","symbol":"query","correct":"const { query } = require('sql-promise')"}],"quickstart":{"code":"const { query } = require('sql-promise');\n\nasync function getUsers() {\n  try {\n    const result = await query('SELECT * FROM users');\n    console.log(result);\n  } catch (err) {\n    console.error(err);\n  }\n}\n\ngetUsers();","lang":"javascript","description":"Shows basic usage: require sql-promise, use query function to run SQL and get a Promise."},"warnings":[{"fix":"Migrate to a maintained alternative like 'mysql2' or 'pg'.","message":"Package status is 'designing' and not actively maintained; may have unfixed bugs.","severity":"deprecated","affected_versions":">=0.0.0"},{"fix":"Use require() or run Node in CommonJS mode.","message":"No ES module support; import will fail with ESM syntax.","severity":"gotcha","affected_versions":">=0.0.0"}],"env_vars":null,"search_vec":"'0.0.19':20 'abstract':65 'activ':54 'adopt':52 'api':18 'async/await':46 'backend':69 'base':17 'broad':51 'cadenc':56 'common':11 'crud':40 'databas':13 'design':26 'develop':28 'differenti':61 'earli':32 'early-stag':31 'enabl':45 'experiment':35 'helper':7 'javascript':80 'key':60 'lack':50 'librari':8,49 'lightweight':64 'mainten':55 'mark':24 'matur':36 'minim':5 'modern':75 'multipl':67 'oper':41 'pattern':47 'promis':3,16,44 'promise-bas':15 'return':43 'simplifi':38 'sql':2,6,12,39,68 'sql-promis':1 'stabl':22 'stage':33 'status':29 'stream':79 'suggest':30 'support':74 'type':77 'typescript':76 'unclear':58 'version':19 'wrap':10","created_at":"2026-06-05T17:02:10.609284+00:00","updated_at":"2026-06-05T17:02:10.609284+00:00","problems":[{"fix":"Run `npm install sql-promise` and ensure it's in node_modules.","cause":"Package may not be installed or is scoped.","error":"Cannot find module 'sql-promise'"},{"fix":"Use `const { query } = require('sql-promise')` instead.","cause":"Using wrong import style (ESM) with a CommonJS package.","error":"TypeError: (0 , _sqlPromise.query) is not a function"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/codenautas/sql-promise","github":"https://github.com/codenautas/sql-promise","docs":null,"changelog":null,"pypi":null,"npm":"sql-promise","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}