415 experiment typesafe query builder single table - Githubissues

mk3008 / Carbunql

Carbunql is an advanced Raw SQL editing library.

https://mk3008.github.io/Carbunql/

MIT License

41 stars 4 forks source link

415 experiment typesafe query builder single table #416

Closed mk3008 closed 4 months ago

mk3008 commented 4 months ago

The following build functions have been implemented.

Added DefineTable function that treats records as table definitions.
Supports SelectAll
Supports column aliases
Supports operators
Supports Coalesce
Added original date calculation function (DateTruncate)
Supports rounding
Supports hard-coding of any SQL command.
Supports RowNumber function
Supports Now function
Supports CurrentTimestamp function
Supports ternary expressions
Supports Trim function
Supports ToString function
Supports LIKE statement
Supports IN clause
Supports ANY function