Using Bookshelf.js with postgis and knex-postgis is a huge pain in the ass.
TLDR - Override Bookshelf methods to parse postgis formats in JS, not in SQL to avoid having to do awkward Bookshelf modifications anywhere you make a bookshelf insert/update/delete on Geo data (middleware like approach)
class Event extends Bookshelf.Model {
get tableName() { return 'event'; }