Type-safe SQL query builder like QueryDSL or JOOQ in Java or Linq in .Net for TypeScript with MariaDB, MySql, Oracle, PostgreSql, Sqlite and SqlServer support.
MIT License
Bot releases are hidden (Show)
Published by juanluispaz almost 2 years ago
Changes:
onlyWhenOrNull
and ignoreWhenAsNull
methods that allows to create an expression that only applies if a certain condition is met; otherwise, the value will be nullBug fixes:
Published by juanluispaz almost 2 years ago
Changes:
dynamicPick
over tables and views past as parameter to a functiondynamicPick
to work with columns coming from other dynamicPick
and to work with complex projectionsextractColumnsFrom
and extractWritableColumnsFrom
to receive a second optional argument with the properties to excludeextractColumnNamesFrom
and extractWritableColumnNamesFrom
that allows to get the column names from a table or viewDocumentation changes:
Internal changes:
Published by juanluispaz almost 2 years ago
Changes:
beforeWithQuery
and afterWithQuery
select query customizationsDocumentation changes:
Published by juanluispaz almost 2 years ago
Changes:
Published by juanluispaz almost 2 years ago
Changes:
Omit
or Pick
in combination with the utility types. Example: type PickValues<COLUMNS, KEYS extends keyof COLUMNS> = SelectedValues<Pick<COLUMNS, KEYS>>;
Published by juanluispaz almost 2 years ago
Changes:
nullIfValue
function that returns null when the provided value is the same otherwise return the initial valueDocumentation changes:
Bug fixes:
join(...).on(...).and/or
pattern is usedgetMonth
method returning wrong value (The returning value must follow JS's Date definition) in PostgreSQL, Sqlite, MariaDB, MySQL, Oracle and SqlServergetSeconds
, getMilliseconds
over a date/time in OraclegetDay
, getSeconds
, getMilliseconds
and getTime
over a date/time in OraclePublished by juanluispaz almost 2 years ago
Bug fixes:
Published by juanluispaz almost 2 years ago
Changes:
returning
clause in MariaDB in insert
and delete
(update
not supported yet by MariaDB)Published by juanluispaz about 2 years ago
Bug fixes:
Published by juanluispaz about 2 years ago
Changes:
allowWhen
and disallowWhen
that throws an error if the expression is used in the final queryDocumentation changes:
Bug fixes:
minValue
and maxValue
returning wrong valuewith
query when a query in a with
clause depends on another with
queryPublished by juanluispaz about 2 years ago
Bug fixes:
Published by juanluispaz about 2 years ago
Bug fixes:
min
and max
functions in the connectionPublished by juanluispaz about 2 years ago
Changes:
valueWhenNoValue
function that allows to return a value when null or undefined were provided to the *IfValue functionPublished by juanluispaz about 2 years ago
Bug fixes:
Published by juanluispaz about 2 years ago
Changes:
onlyWhen
and ignoreWhen
function that allows ignoring a boolean expression under a conditionInsertableValues
, UpdatableValues
and SelectedValues
that allows to get the types for an insert, update and select with the proper types defined in the table without the other sql objectsPublished by juanluispaz about 2 years ago
Bug fixes:
left outer join
Published by juanluispaz over 2 years ago
Bug fixes:
IfValue
is used and there is no valuePublished by juanluispaz over 2 years ago
Changes:
LoggingQueryRunner
callbacksConsoleLogQueryRunner
more configurable so that it can output results, timestamps and durations as wellBug fixes:
Published by juanluispaz over 2 years ago
Changes:
Published by juanluispaz over 2 years ago
Re-release 1.27.0 due a mkdocs bug.
1.27.0 changes:
Documentation changes:
Bug fixes: