this workaround was working for me but now it's back to the giving me the same error. I'm on debian 12:
/run/build/AdwaitaTemplate/.build/checkouts/SQLite.swift/Sources/SQLite/Core/Backup.swift:36:8: error: no such module 'SQLite3'
34 | import SQLiteSwiftCSQLite
35 | #else
36 | import SQLite3 // SystemSQLite
|- error: no such module 'SQLite3'
37 | #endif
38 | `