Release v.2.0.0
Changes:
- MySQL and MariaDB support:
- SELECT
(DISTINCT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET, FOR, UNION, LOCK_IN_SHARE_MODE, sub-queries)
- INSERT
(VALUES, query)
, - UPDATE
(SET, WHERE)
, - DELETE
(WHERE, ORDER_BY, LIMIT)
, - LOCK
(READ, WRITE)
- SELECT
- PostgreSQL import part has changed:
github.com/go-jet/jet
->github.com/go-jet/jet/postgres
- Query execution mapping will also try to convert result set object to destination type if such a conversion is allowed.
- For every time type there is now a constructor method that accepts
time.Time
(DateT, TimeT, TimestampT, TimezT...
) - Some methods and types are changed or replaced:
Sql()
andDebuSql
does not return error as a last parameter. If there is an error in statement this methods will panic.RAW
->Raw
SIMILAR_TO
->REGEXP_LIKE
NOT_SIMILAR_TO
->NOT_REGEXP_LIKE
ColumnList{column1, ...}
->ColumnList(column1, ...)