Arch Linux

According to that page, it's only disabled by default in the amalgamation, which we don't use to build.

The /usr/bin/sqlite3 tool successfully runs the example stmt queries for me. Why do you think this is missing?

I see, yes the binary works, the issue is that somehow Ruby is having trouble linking correctly as illustrated by this Dockerfile:

```
FROM archlinux

RUN pacman -Syu --noconfirm
RUN pacman -S --noconfirm ruby sqlite
RUN pacman -S --noconfirm base-devel
RUN gem install sqlite3
RUN sqlite3 test.db "SELECT * FROM SQLITE_STMT"
RUN ruby -e "require 'sqlite3'; db = SQLite3::Database.new 'test.db'; db.execute 'select * from SQLITE_STMT'"
```

Once I apply this the issue goes away:

```
--- a/sqlite/trunk/PKGBUILD
+++ b/sqlite/trunk/PKGBUILD
@@ -40,6 +40,7 @@ build() {
-DSQLITE_ENABLE_DBSTAT_VTAB=1 \
-DSQLITE_ENABLE_FTS3_TOKENIZER=1 \
-DSQLITE_SECURE_DELETE \
+ -DSQLITE_ENABLE_STMTVTAB \
-DSQLITE_MAX_VARIABLE_NUMBER=250000 \
-DSQLITE_MAX_EXPR_DEPTH=10000"
```

I guess the default amalgamation is the problem for rubygems

Debian is good per:

```
FROM debian

RUN apt-get update
RUN apt-get install -y ruby build-essential
RUN apt-get install -y sqlite libsqlite3-dev
RUN apt-get install -y ruby-dev
RUN gem install sqlite3-ruby
RUN sqlite3 test.db "SELECT * FROM SQLITE_STMT"
RUN ruby -e "require 'sqlite3'; db = SQLite3::Database.new 'test.db'; db.execute 'select * from SQLITE_STMT'"
```

"the amalgamation" is source code intended for including in a project as sqlite3.o rather than downloading the standard source code with the standard 'make install' infrastructure, compiling a system libsqlite3.so, and linking to it later on. It's not relevant here.

ruby-sqlite3 links to core/sqlite

$ pkg-list-linked-libraries ruby-sqlite3 libsql
==> checking linked libraries for ruby-sqlite3-1.4.2-2-x86_64.pkg.tar.xz ...
usr/lib/ruby/gems/2.7.0/extensions/x86_64-linux/2.7.0/sqlite3-1.4.2/sqlite3/sqlite3_native.so
NEEDED libsqlite3.so.0

$ sudo pacman -S ruby-sqlite3 && ruby -e "require 'sqlite3'; db = SQLite3::Database.new 'test.db'; db.execute 'select * from SQLITE_STMT'"
/usr/lib/ruby/gems/2.7.0/gems/sqlite3-1.4.2/lib/sqlite3/database.rb:147:in `initialize': no such table: SQLITE_STMT (SQLite3::SQLException)


So, the implication is that libsqlite3 does not enable SQLITE_STMT, only the CLI tool does... that's interesting.

Please try 3.35.2-2 from testing repo.

Confirming `3.35.2-2` looks good to me! Thanks!