One advantage of the template approach is it allows for test level parallelism, which may address your primary goal of performance. > Waterline queries are cas

One advantage of the template approach is it allows for test level parallelism, which may address your primary goal of performance. > Waterline queries are case insensitive; that is, Users.find().where(name: 'FOO') will turn into SELECT * FROM users WHERE name = LOWER('FOO');. There's no way to turn this off. If you ask Sails to generate an index for you, it will place the index on the uppercased column name, so your queries will miss it. If you generate the index yourself, you pretty much have to use the lowercased column value & force every other query against the database to use that as well. What the actual fuck!