const parser = require('js-sql-parser');
const ast = parser.parse('WITH t as ( delete from foo ) Delete from bar;')
console.log(JSON.stringify(ast, null, 2));