workers-qb

What's Changed

• Add upsert support by @G4brym in https://github.com/G4brym/workers-qb/pull/36

Full Changelog: https://github.com/G4brym/workers-qb/compare/v1.0.2...v1.1.0

What's Changed

• Update top-level types path by @programbo in https://github.com/G4brym/workers-qb/pull/31

Full Changelog: https://github.com/G4brym/workers-qb/compare/v1.0.1...v1.0.2

What's Changed

• Fix type definition by @G4brym in https://github.com/G4brym/workers-qb/pull/29
• Fix FetchOne() to start returning undefined when no results by @G4brym in https://github.com/G4brym/workers-qb/pull/30

Full Changelog: https://github.com/G4brym/workers-qb/compare/v1.0.0...v1.0.1

Breaking Changes

• For upgrading you must append .execute() at the end of every query, read more here

What's Changed

• D1 batch queries by @ejyager00 in https://github.com/G4brym/workers-qb/pull/25
• Fix bug when passing execute function in creation of new Query by @ejyager00 in https://github.com/G4brym/workers-qb/pull/26
• Update docs to match new interface and refactor tests by @G4brym in https://github.com/G4brym/workers-qb/pull/27

Full Changelog: https://github.com/G4brym/workers-qb/compare/v0.1.12...v1.0.0

What's Changed

• Add debugger option to see generated query + parameters by @G4brym in https://github.com/G4brym/workers-qb/pull/23
• Allow use of subqueries in join clauses by @ejyager00 in https://github.com/G4brym/workers-qb/pull/24

Full Changelog: https://github.com/G4brym/workers-qb/compare/v0.1.11...v0.1.12

Fixes

• Fix D1 insert() to respect response schema

Full Changelog: https://github.com/G4brym/workers-qb/compare/v0.1.10...v0.1.11

Breaking Changes

• Simplified .insert()response format to make results a single object when inserting a single record
  • If you are using .insert() with the returning option, and inserting a single record, you will be required to update the code from const user = inserted.results[0] into const user = inserted.results
  • If you are inserting multiple record at once or not using the returning option, no change is required from you

Fixes

• Fix Raw parameter from being sent to the database as an argument

Full Changelog: https://github.com/G4brym/workers-qb/compare/v0.1.9...v0.1.10

What's Changed

• Fix requiring node_compat=true when using D1 only

Full Changelog: https://github.com/G4brym/workers-qb/compare/v0.1.8...v0.1.9

What's Changed

• Add support for node-postgres using the new Cloudflare Workers TCP sockets

Full Changelog: https://github.com/G4brym/workers-qb/compare/v0.1.7...v0.1.8

What's Changed

• Improve automatic imports

Full Changelog: https://github.com/G4brym/workers-qb/compare/v0.1.6...v0.1.7

What's Changed

• Add bulk insert

Full Changelog: https://github.com/G4brym/workers-qb/compare/v0.1.5...v0.1.6

What's Changed

• Fix Raw class not being exported

Full Changelog: https://github.com/G4brym/workers-qb/compare/v0.1.4...v0.1.5

What's Changed

• Add raw sql parameters
• Add support for multiple joins
• Add docs for adding third party databases

Full Changelog: https://github.com/G4brym/workers-qb/compare/v0.1.3...v0.1.4

What's Changed

• Add support for join clauses
• Add support for on conflict clauses
• Fix update syntax and parameter position
• Improve ci/cd for new releases

Full Changelog: https://github.com/G4brym/workers-qb/compare/v0.1.2...v0.1.3