You’re welcome! I was really determined to figure out what was wrong here, because I was really tired of wasting time trying to figure out why nothing was working for our Mac developers. Coincidentally, I wound up here because of your nice DataAccess plugin, which has been extremely helpful. Thanks for publishing that!
This seems to have done the trick. You still need to edit the SQLiteSupport.Build.cs file to check for the libsqlite.a file instead of sqlite.a because if the sqlite.a does not exist the Build file throws an error. Good stuff though, not I’m getting architecture errors which is further than before 
Anyone who got here, compile the library as follows:
clang -c -arch x86_64 sqlite3.c
Oh, wow, you’re right. I thought I cleaned up my build while I was testing this, but I must have left both the “sqlite.a” and “libsqlite.a” files, so I never got caught by the Build.cs check for the file existing.
We hope this plugin can help you.
The UE5 version: