AlbertoGiani ,
Please do not make duplicate posts (see Nodered 1.20.0 + 3.0.2-ctrlx, can't install sqlite). I was able to reproduce this with your versions. This is a problem specific to the virtual CORE architecture. In the pallet documentation, native code is compiled on the device during installation and this is where the failure occurs. The npm package sqlite3 is used which looks to only be supported on arm architecture.
Unfortunately, prebuild cannot differentiate between armv6 and armv7, and instead uses arm as the {arch}. Until that is fixed, you will still need to install sqlite3 from source.
As this is a 3rd party node, this is about as much support as I can provide here. It should work fine on an arm device.