Rewrite for better performance & API

[DjDeveloperr]

Goals:

• Optimize for fastapi calls
• Take inspiration from better-sqlite3 (Node.js) API as it is simple and concise

Previously:

Now:

[littledivy]

Bun is caching column names / count and does no validation if you alter schema from another process. It has an unfair advantage here, let's not choose the bad actor as the baseline.

[waynebloss]

One thing I noticed about the Bun and the better-sqlite3 implementations is that they don't make you call sqlite3_finalize for prepared statements. That's because they use destructors in the C++ implementations [0] [1].

I know we don't have destructors in JS, but I'm wondering if you would consider using something like the FinalizationRegistry API to do this?

[0] Bun JSSQLStatement destructor

[1] better-sqlite3 Statement destructor

[DjDeveloperr]

I know we don't have destructors in JS, but I'm wondering if you would consider using something like the FinalizationRegistry API to do this?

Yup - good idea, added it now

[DjDeveloperr]

Had to revert finalizer... causing unexpected exits during tests weirdly only on Windows CI

[DjDeveloperr]

Managed to fix finalizer