I noticed that randomly test fails on my machine (docker hosted on macos 13). This is (probably) caused by 2 issues:

1. missed await on query("BEGIN")
2. the use of TRUNCATE on each test.

as explained here (https://www.postgresql.org/docs/current/mvcc-caveats.html) TRUNCATE is not MVCC-safe (Multi-Version Concurrency Control).

This PR adds the missing await and converts all the TRUNCATE users in DELETE FROM "users" WHERE TRUE.

Because the tests inside the req-initialization file do not verify user IDs, the proposed query has the same effect as a TRUNCATE in this context

Checklist

• run npm run test
• tests and/or benchmarks are included
• documentation is changed or added
• commit message and code follows the Developer's Certification of Origin
  and the Code of conduct