A simple sql builder.
npm install @stormzx/sqlbuilder1. table(tablename:string, as?:string)
`` javascript
import { table } from '@stormzx/sqlbuilder'
let u = table('users', 'u')
let transform =
# use like object
u => ${u}
u.id => ${u.id}
u.userId => ${u.userId}
u.userId.as('uid') => ${u.userId.as('uid')}
# use like function
u('id', 'userId') = [u.id, u.userId] => ${u('id', 'userId')}
u('id', ['userId', 'uid']) = [u.id, u.userId.as('uid')] => ${u('id', ['userId', 'uid'])}
console.log(transform)
// Output:
// # use like object
// u => users as uu
// u.id => .idu
// u.userId => .user_idu
// u.userId.as('uid') => .user_id as uid
// # use like function
// u('id', 'userId') = [u.id, u.userId] => u.id,u.user_idu
// u('id', ['userId', 'uid']) = [u.id, u.userId.as('uid')] => .id,u.0 as uid
`
2. raw(rawSql: string)
3. escape(value: any)
4. escapeId(column: string)
5. SQLBuilder
` javascript
import {SQLBuilder, table} from '@stormzx/sqlbuilder'
let u = table('users', 'u')
``