Releases: themost-framework/query
Releases · themost-framework/query
2.9.5
2.9.4
What's Changed
- support $it while escaping value by @kbarbounakis in #62
- Add extra methods by @kbarbounakis in #63
Full Changelog: 2.9.2...2.9.4
2.9.2
What's Changed
- Support object destructuring by @kbarbounakis in #61
@themost/query
closures support object destructuring while selecting attributes e.g.
new QueryExpression().select(({id, familyName, givenName}) => {
id,
familyName,
givenName
})
.from(People).where( x => {
return x.id === 355;
});
or while querying data:
new QueryExpression()
.select(({ id, familyName: lastName, givenName: firstName, email, dateCreated }) => {
id, lastName, firstName, email, dateCreated
})
.from(People)
.where(({ email }) => {
return email === 'cameron.ball@example.com';
})
.take(1);
which produces the folllowing equivalent SQL:
SELECT "PersonData"."id" AS "id", "PersonData"."familyName" AS "lastName", "PersonData"."givenName" AS "firstName", "PersonData"."email" AS "email", "PersonData"."dateCreated" AS "dateCreated" FROM "PersonData" WHERE "PersonData"."email" = 'cameron.ball@example.com' LIMIT 1
Full Changelog: 2.9.1...2.9.2
2.9.1
2.9.0
What's Changed
- add case function for open data formatter by @kbarbounakis in #59
Full Changelog: 2.8.2...2.9.0
2.8.2
What's Changed
- Use method expression while ordering by @kbarbounakis in #58
Full Changelog: 2.8.1...2.8.2
2.8.1
What's Changed
- Add open data query formatter by @kbarbounakis in #55
- validate open data formatter by @kbarbounakis in #56
- Bump json5 from 2.2.1 to 2.2.3 by @dependabot in #57
New Contributors
- @dependabot made their first contribution in #57
Full Changelog: 2.8.0...2.8.1
2.8.0
What's Changed
- Extend QueryExpression.groupBy by @kbarbounakis in #54
Full Changelog: 2.7.11...2.8.0
2.7.11
What's Changed
- use where formatter by @kbarbounakis in #51
- use query entity object by @kbarbounakis in #53
Full Changelog: 2.7.10...2.7.11