The installation of RSQLite 2.3.10 fails when SQLite is in a custom path. Neither exporting PKG_CONFIG_PATH=/opt/sqlite/3.49.1/lib/pkgconfig nor R CMD INSTALL --configure-vars="LIB_DIR='/opt/sqlite/3.49.1/lib' INCLUDE_DIR='/opt/sqlite/3.49.1/include'" RSQLite_2.3.10.tar.gz work. The compilation stops at ext-csv.c

gcc -I"/lisc/app/R/4.2.3/lib64/R/include" -DNDEBUG -Ivendor -DRSQLITE_USE_BUNDLED_SQLITE -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_STAT4 -DSQLITE_SOUNDEX -DSQLITE_USE_URI=1 -DSQLITE_MAX_LENGTH=2147483647 -DHAVE_USLEEP=1 -I'/lisc/app/R/4.2.3/lib64/R/library/plogr/include' -I'/lisc/app/R/4.2.3/lib64/R/library/cpp11/include' -I/usr/local/include -fvisibility=hidden -fpic -g -O2 -c ext-csv.c -o ext-csv.o
In file included from ext-csv.c:5:
vendor/extensions/csv.c:42:10: fatal error: sqlite3ext.h: No such file or directory
42 | #include <sqlite3ext.h>
| ^~~~~~~~~~~~~~
compilation terminated.

The problem did not exist in 2.3.9.