Possible to provide a custom sqlite build?

[tantaman]

SQLite has many compile time options which control various things like:

• statically loaded extensions
• query planning limits
• setting max memory

As well as a few branches which are supported by the SQLite team and popular among other users. Two of the most used branches for alternative sqlite builds being bedrock & wal2: https://www.sqlite.org/src/doc/wal2/doc/wal2.md

It would be ideal if bun allowed users with advanced sqlite use cases to bring their own sqlite build. I see this is possible on macos but that the feature is a no-op on other platforms, making it effectively useless given an app will not be deployed to production on macos.

It looks like this is controlled by whether or not LAZY_LOAD_SQLITE is defined:

bun/src/bun.js/bindings/sqlite/JSSQLStatement.cpp

Lines 1052 to 1058 in fd894f5

	#if LAZY_LOAD_SQLITE
	if (sqlite3_handle) {
	throwException(lexicalGlobalObject, scope, createError(lexicalGlobalObject, "SQLite already loaded\nThis function can only be called before SQLite has been loaded and exactly once. SQLite auto-loads when the first time you open a Database."_s));
	return {};
	}
	sqlite3_lib_path = sqliteStrValue.toWTFString(lexicalGlobalObject).utf8().data();

Would a PR to allow custom sqlite builds in Bun be accepted? If so, what is the proper direction? E.g., having all platforms lazily load sqlite or something else?

We're looking into porting the backend of Zero from Node to Bun (pending some perf measurements) but we require the wal2 branch of sqlite.

Thanks.