Custom SQL.

[KyGuyMayor]

Is there a way to use custom sql queries like the query method in the Sails documentation? Here is a link to the documentation I am referring to: http://sailsjs.com/documentation/reference/waterline-orm/models/query

[cope]

I'd like to know that too.

But it looks like no one os maintaining this adapter anymore :(

[KyGuyMayor]

I was able to fix this by adding this function to lib/adapter.js at line 389

query(connectionName, collection, collectionName, queryObj, cb) { this.datastore.adapter.executeQuery(connectionName, queryObj, function (err, results) { if ( err) return cb(err); cb(null, results && results.rows); }); },

You can call it like this. Model.query({ sql: sql, params { term: term } }, function callback(err, results) { ... });