node:sqlite alignment regarding api

[halvardssm]

What is the problem this feature will solve?

If you’ve spent any time working with SQL databases in JavaScript, you’ve probably noticed how each database driver has its own way of doing things. Whether you’re connecting to MySQL, PostgreSQL, SQLite, or SQL Server, you’ve had to adapt to different interfaces and quirks. While this diversity showcases the richness of our ecosystem, it can also lead to a lot of headaches. Learning new APIs, dealing with inconsistencies, and maintaining codebases that juggle multiple database drivers can be a real challenge.

What is the feature you are proposing to solve the problem?

Along with database driver maintainers and the deno std team, we have been working on this RFC. What is missing is input from the node team developing the node:sqlite package, and hopefully some shared insight from all parties can be used to create a general base interface that can be implemented across the exosystem. I want to specify that base interface means that it can be extended with methods and options to fit the individual needs of each database, but that the core api stays the same.

What alternatives have you considered?

That the JS ecosystem does not have a unified approach to database interaction.