sedk-mysql

import { Database, Schema, Table, TextColumn, NumberColumn, BooleanColumn, DateColumn, builder, LogicalOperator } from 'sedk-mysql' const database = new Database({ version: 1, schemas: { public: new Schema({ name: 'public', tables: { Employee: new Table({ name: 'Employee', columns: { name: new TextColumn({ name: 'name' }), salary: new NumberColumn({ name: 'salary' }), isManager: new BooleanColumn({ name: 'isManager' }), startDate: new DateColumn({ name: 'startDate' }), }, }), }, }), }, }) const Employee = database.s.public.t.Employee const name = Employee.c.name const salary = Employee.c.salary const AND = LogicalOperator.AND const sql = builder(database) const stmt = sql .select(name, salary) .from(Employee) .where(name.eq$('John'), AND, salary.gt$(1500)) .getSQL() console.log(stmt) // SELECT `name`, `salary` FROM `Employee` WHERE ( `name` = ? AND `salary` > ? ) const bindValues = sql .select(name, salary) .from(Employee) .where(name.eq$('John'), AND, salary.gt$(1500)) .getBindValues() console.log(bindValues) // [ 'John', 1500 ]