I think actually running tests would be more appropriate than simply making declarations. SQLite's locking mechanism will synchronize a lot of activity anyway.
What you probably should do, if there's lots of other things going on, if you're using SQLite with Node.js, is segment your database requests into a separate worker. This is going to be regardless of the SQL library you choose.
Beyond this, I'm not a fan of ORMs in scripted languages anyway. It adds a lot of overhead for almost no real value.