createView - nodef/extra-sql GitHub Wiki

Generates SQL command for CREATE VIEW.

sql.createView(name, query, [options]);
// name:  view name
// query: view query
// options: options

const sql = require('extra-sql');

sql.createView('food_code', 'SELECT "code" FROM "food"');
// CREATE OR REPLACE VIEW "food_code" AS SELECT "code" FROM "food";