Params not working in WITH AS queries

[rory1212]

When you trying to execute WITH AS query with parameters, It's not working.

My solution is:

sqlite.prototype.run = function (sql, options, callback) {
	if (typeof (options) == "function") {
		callback = options;
		options = [];
	}
	var results;
	var type = sql.substring(0, 6);
	type = type.toUpperCase();
	if (type.startsWith('WITH')) {
		type = 'WITH';
	}
	switch (type) {
		case "SELECT":
		case "WITH":
			results = this.pvSELECT(sql, options);
			break;
		case "INSERT":
			results = this.pvINSERT(sql, options);
			break;
		case "UPDATE":
			results = this.pvUPDATE(sql, options);
			break;
		case "DELETE":
			results = this.pvDELETE(sql, options);
			break;
		case "PRAGMA":
			results = this.pvPRAGMA(sql, options);
			break;
		default:
			results = this.runAll(sql)
	}
	if (callback) {
		callback(results);
		return this;
	} else {
		return results;
	}
};