René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlite: db.prepare(sql, options)","articleBody":"# Problem\n\nCurrently you need multiple js statements to declare a single [SQLite](https://nodejs.org/api/sqlite.html) statement with options like `returnArrays`, `readBigInts` etc. This requires multiple lines and can be inefficient to call c++ multiple times:\n\n```js\n\nconst q = db.prepare(sql);\nq.setReturnArrays(true);\nq.setReadBigInts(true);\nq.setAllowBareNamedParameters(true);\nq.setAllowUnknownNamedParameters(true);\n```\n\n# Proposal 1\n\nAllow chaining `statement.set*` functions by returning the sql statement instead of `undefined`. This allows declaring a sql statement with 1 JS statement. This still requires multiple function calls but is slightly better DX developer experience using the existing `set*` functions:\n\n```js\n// before\nconst q = db.prepare(sql);\nq.setReturnArrays(true);\n\n// after\nconst q = db.prepare(sql).setReturnArrays(true);\n\n// more example\nconst q = db.prepare(sql).setReturnArrays(true).setReadBigInts(true);\n```\nPR: https://github.com/nodejs/node/pull/61263\n\n# Proposal 2\n\nAdd options argument: `db.prepare(sql[, options])`\n\n```js\n// before\nconst q = db.prepare(sql);\nq.setReturnArrays(true);\n\n// after\nconst q = db.prepare(sql, { returnArrays: true });\n\n// more example\nconst q = db.prepare(sql, { returnArrays: true, readBigInts: true });\n\n```\nIn this case I recommend to remove the `statement.set*` functions to simplify the API, you only need `db.prepare(sql[, options])`\n\n# Proposal 3\n\nDo both Proposal 1 and Proposal 2. Currently I am leaning towards Proposal 2 and removing set* functions","author":{"url":"https://github.com/mike-git374","@type":"Person","name":"mike-git374"},"datePublished":"2026-01-01T16:56:55.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/61235/node/issues/61235"}