RTREE module is not activated by default

Hi,

It seems that the RTREE extension is not activated by default in react-native-nitro-sqlite.

While performing a schema migration with the following SQL command:

ALTER TABLE mytable RENAME TO mynewtablename;

I encountered the following error:

no such module: rtree

By adding manually in node_modules\react-native-nitro-sqlite\android\CMakeLists.txt:

add_definitions(
-DSQLITE_ENABLE_RTREE
)

The issue is solved, but can it be enabled by default ?
This would help ensure compatibility with databases or queries that depend on RTREE features.

Thanks!

Start with android/CMakeLists.txt and inspect how SQLite compile definitions are configured. Reproduce the ALTER TABLE migration that reports “no such module: rtree,” then verify that enabling RTREE by default allows the Android build and migration to complete without requiring a manual node_modules edit.