SQL string builder.
npm install @gallink/sequenceISequenceBuilder implementations such as Select, you can build any SQL statement to suit your needs -- if not, the entire library has been designed by interface allowing extension in any way you can think of.
typescript
// Create your column.
const column: ISequenceColumn = new SequenceColumn(Predicate.None, "username");
// Build your statement.
const select: ISequenceBuilder = new Select()
.from("user")
.where(column, LogicalOperator.Equality, "Crowes");
// Stringify your statement.
const sql: string = select.stringify();
// SELECT * FROM user WHERE userName = 'Crowes'
`
$3
`typescript
// Create your columns.
const columnA: ISequenceColumn = new SequenceColumn(Predicate.None, "username")
const columnB: ISequenceColumn = new SequenceColumn(Predicate.None, "password")
// Build your statement
const insert: ISequenceBuilder = new Insert()
.into("user", columnA, columnB)
.values("Crowes", 1234);
// Stringify your statement.
const sql: string = insert.stringify();
// INSERT INTO user (userName, userPassword) VALUES ('crowes', 1234)
`
$3
`typescript
// Create your column.
const column: ISequenceColumn = new SequenceColumn(Predicate.None, "username");
// Build your statement.
const delete: ISequenceBuilder = new Delete()
.from("user")
.where(column, LogicalOperator.Equality, "Crowes");
// Stringify your statement.
const sql: string = select.stringify();
// SELECT * FROM user WHERE userName = 'Crowes'
``