Normally, RPMs installed on AIX are installed under /opt/freeware/bin (executables) or /opt/freeware/lib (libraries).
If you installed an RPM package for gpg, libsqlite3 or other, most likely the libraries are installed in the above directories above.
If root is able to run the gpg command without any issues, it is likely because it has an update LIBPATH (or LD_LIBRARY_PATH) variable which contains the lib directory mentioned above, but the regular user does not. If that is the case, then update the .profile (or .kshrc or .bashrc) and update the LIBPATH or LD_LIBRARY_PATH to include /opt/freeware/lib (or whatever directory you installed the RPM under, if not the default).
Also, please note that the /usr/lib/libsqlite3.a or /usr/lib/libsqlite3.so files are files included in the rpm.rte fileset (not necessarily related to the RPM version of those files)
# rpm -qa | grep sql
sqlite-3.41.2-1.ppc
# lslpp -f rpm.rte | grep sql
/usr/opt/rpm/lib/libsqlite3.a
/usr/opt/rpm/old_rpmdb/lib/libsqlite3.so
# ls -l /usr/lib/libsq* /opt/free*/lib/libsq*
-rwxr-xr-x 1 root system 13921375 Mar 31 2023 /opt/freeware/lib/libsqlite3.a # these files are from the sqlite3 RPM
-rwxr-xr-x 1 root system 6506788 Mar 31 2023 /opt/freeware/lib/libsqlite3.so # these files are from the sqlite3 RPM
lrwxrwxrwx 1 root system 29 Jun 28 00:40 /usr/lib/libsqlite3.a -> /usr/opt/rpm/lib/libsqlite3.a # these files are from the rpm.rte fileset
lrwxrwxrwx 1 root system 30 Nov 21 2023 /usr/lib/libsqlite3.so -> /usr/opt/rpm/lib/libsqlite3.so # these files are from the rpm.rte fileset
Based in the error that you are getting, it is likely that the gpg command is picking up the libsqlite3.a file from the rpm.rte fileset location instead of the one for sqllite3 RPM
------------------------------
Abraham Alvarez
------------------------------