@effect/sql

0.18.10

Patch Changes

Updated dependencies [2367708]:
- @effect/platform@0.69.9
- effect@3.10.4
- @effect/experimental@0.30.10

0.18.9

Patch Changes

Updated dependencies [522f7c5]:
- @effect/platform@0.69.8
- @effect/experimental@0.30.9

0.18.8

Patch Changes

Updated dependencies [690d6c5, b9423d8, 279fe3a]:
- @effect/platform@0.69.7
- effect@3.10.3
- @effect/experimental@0.30.8

0.18.7

Patch Changes

Updated dependencies [714e119, c1afd55, 42cd72a]:
- effect@3.10.2
- @effect/platform@0.69.6
- @effect/experimental@0.30.7

0.18.6

Patch Changes

Updated dependencies [9604d6b, 9604d6b]:
- @effect/experimental@0.30.6
- effect@3.10.1
- @effect/platform@0.69.5

0.18.5

Patch Changes

Updated dependencies [c86b1d7]:
- @effect/platform@0.69.4
- @effect/experimental@0.30.5

0.18.4

Patch Changes

Updated dependencies [d5fba63, 1eb2c30, 02d413e]:
- @effect/platform@0.69.3
- @effect/experimental@0.30.4

0.18.3

Patch Changes

Updated dependencies [e7afc47]:
- @effect/platform@0.69.2
- @effect/experimental@0.30.3

0.18.2

Patch Changes

Updated dependencies []:
- @effect/experimental@0.30.2

0.18.1

Patch Changes

Updated dependencies [7564f56, 7564f56]:
- @effect/platform@0.69.1
- @effect/experimental@0.30.1

0.18.0

Patch Changes

Updated dependencies [4a01828, 6d9de6b, 4a01828, c79c4c1, 38d30f0, 5821ce3]:
- effect@3.10.0
- @effect/platform@0.69.0
- @effect/experimental@0.30.0

0.17.0

Minor Changes

#3760 dacbf7d Thanks @tim-smart! - add sql-clickhouse & clickhouse dialect

0.16.6

Patch Changes

Updated dependencies [382556f, 97cb014]:
- @effect/schema@0.75.5
- @effect/experimental@0.29.6
- @effect/platform@0.68.6

0.16.5

Patch Changes

Updated dependencies [2036402]:
- @effect/platform@0.68.5
- @effect/experimental@0.29.5

0.16.4

Patch Changes

Updated dependencies [1b1ef29]:
- @effect/platform@0.68.4
- @effect/experimental@0.29.4

0.16.3

Patch Changes

Updated dependencies [61a99b2, 8c33087]:
- effect@3.9.2
- @effect/platform@0.68.3
- @effect/experimental@0.29.3
- @effect/schema@0.75.4

0.16.2

Patch Changes

Updated dependencies [bd160a4, 360ec14]:
- @effect/experimental@0.29.2
- @effect/schema@0.75.3
- @effect/platform@0.68.2

0.16.1

Patch Changes

Updated dependencies [b75ac5d]:
- @effect/platform@0.68.1
- @effect/experimental@0.29.1

0.16.0

Patch Changes

#3720 e0a5dad Thanks @jkonowitch! - add SqlClient.makeWithTransaction api
Updated dependencies [f02b354, 90ceeab, 90ceeab, 90ceeab]:
- @effect/schema@0.75.2
- @effect/platform@0.68.0
- @effect/experimental@0.29.0

0.15.1

Patch Changes

Updated dependencies [3b2ad1d]:
- @effect/platform@0.67.1
- effect@3.9.1
- @effect/schema@0.75.1
- @effect/experimental@0.28.1

0.15.0

Patch Changes

Updated dependencies [ff3d1aa, 0ba66f2, bf77f51, 016f9ad, 0779681, 534129f, d75140c, be0451c, 9237ac6, be0451c, 5b36494, c716adb, 4986391, d75140c, d1387ae]:
- effect@3.9.0
- @effect/platform@0.67.0
- @effect/schema@0.75.0
- @effect/experimental@0.28.0

0.14.1

Patch Changes

Updated dependencies [88e85db, f40da15, 8e94585, 83887ca, 5266b6c, cdead5c, f40da15, 766a8af]:
- effect@3.8.5
- @effect/platform@0.66.3
- @effect/experimental@0.27.4
- @effect/schema@0.74.2

0.14.0

Minor Changes

#3683 f100e20 Thanks @tim-smart! - use decoded ids in sql resolvers

0.13.4

Patch Changes

Updated dependencies []:
- @effect/experimental@0.27.3

0.13.3

Patch Changes

#3676 0a68746 Thanks @tomglaize! - Add VariantSchema fieldFromKey utility to rename the encoded side of a field by variant.

Example usage:

import { Schema } from "@effect/schema"
import { VariantSchema } from "@effect/experimental"

const { Class, fieldFromKey } = VariantSchema.make({
  variants: ["domain", "json"],
  defaultVariant: "domain"
})

class User extends Class<User>("User")({
  id: Schema.Int,
  firstName: Schema.String.pipe(fieldFromKey({ json: "first_name" }))
}) {}

console.log(
  Schema.encodeSync(User.json)({
    id: 1,
    firstName: "Bob"
  })
)
/*
{ id: 1, first_name: 'Bob' }
*/

Updated dependencies [0a68746, 734eae6, fd83d0e, 4509656, ad7e1de, 090e41c, 090e41c]:
- @effect/experimental@0.27.2
- @effect/schema@0.74.1
- @effect/platform@0.66.2
- effect@3.8.4

0.13.2

Patch Changes

Updated dependencies [3812788]:
- @effect/platform@0.66.1
- @effect/experimental@0.27.1

0.13.1

Patch Changes

#3657 d5c8e7e Thanks @jamiehodge! - fix Model findById data loader

0.13.0

Patch Changes

Updated dependencies [de48aa5]:
- @effect/schema@0.74.0
- @effect/experimental@0.27.0
- @effect/platform@0.66.0

0.12.6

Patch Changes

Updated dependencies [321b201, bb5ec6b]:
- @effect/platform@0.65.5
- effect@3.8.3
- @effect/experimental@0.26.6
- @effect/schema@0.73.4

0.12.5

Patch Changes

Updated dependencies [e6440a7]:
- @effect/schema@0.73.3
- @effect/experimental@0.26.5
- @effect/platform@0.65.4

0.12.4

Patch Changes

Updated dependencies [b86b47d]:
- @effect/experimental@0.26.4

0.12.3

Patch Changes

Updated dependencies [f0d8ef1]:
- effect@3.8.2
- @effect/experimental@0.26.3
- @effect/platform@0.65.3
- @effect/schema@0.73.2

0.12.2

Patch Changes

Updated dependencies [10bf621, f56ab78, ae36fa6]:
- effect@3.8.1
- @effect/schema@0.73.1
- @effect/experimental@0.26.2
- @effect/platform@0.65.2

0.12.1

Patch Changes

Updated dependencies [e44c5f2]:
- @effect/platform@0.65.1
- @effect/experimental@0.26.1

0.12.0

Patch Changes

Updated dependencies [fcfa6ee, bb9931b, 5798f76, 5f0bfa1, 7fdf9d9, 812a4e8, 6a128f6, 273565e, adf7d7a, 569a801, aa1fa53, 02f6b06, 12b893e, bbad27e, 7041393, e0d21a5, adf7d7a, 007289a, 42a8f99, eebfd29, 040703d]:
- effect@3.8.0
- @effect/experimental@0.26.0
- @effect/schema@0.73.0
- @effect/platform@0.65.0

0.11.3

Patch Changes

#3600 ccd67df Thanks @tim-smart! - remove network roundtrip from mysql update in Model repository

0.11.2

Patch Changes

#3599 d8aff79 Thanks @tim-smart! - fix mysql support for Model.makeRepository
#3599 d8aff79 Thanks @tim-smart! - add insertVoid & updateVoid to Model repository
Updated dependencies [35a0f81, 8261c5a]:
- effect@3.7.3
- @effect/platform@0.64.1
- @effect/experimental@0.25.2
- @effect/schema@0.72.4

0.11.1

Patch Changes

Updated dependencies [ce86193]:
- @effect/experimental@0.25.1

0.11.0

Patch Changes

Updated dependencies [f6acb71, 90ac8f6, 90ac8f6, 3791e24, 3791e24]:
- @effect/schema@0.72.3
- @effect/platform@0.64.0
- @effect/experimental@0.25.0

0.10.4

Patch Changes

Updated dependencies [c969f74]:
- @effect/experimental@0.24.4

0.10.3

Patch Changes

Updated dependencies [4a701c4]:
- @effect/platform@0.63.3
- @effect/experimental@0.24.3

0.10.2

Patch Changes

Updated dependencies [8a601d7, 353ba19]:
- effect@3.7.2
- @effect/experimental@0.24.2
- @effect/platform@0.63.2
- @effect/schema@0.72.2

0.10.1

Patch Changes

Updated dependencies [79859e7, f6a469c, dcb9ec0, 79aa6b1]:
- effect@3.7.1
- @effect/experimental@0.24.1
- @effect/platform@0.63.1
- @effect/schema@0.72.1

0.10.0

Patch Changes

Updated dependencies [db89601, 2f456cc, 8745e41, e557838, d6e7e40, 8356321, 192f2eb, 718cb70, e9d0310, 6bf28f7]:
- effect@3.7.0
- @effect/platform@0.63.0
- @effect/experimental@0.24.0
- @effect/schema@0.72.0

0.9.7

Patch Changes

Updated dependencies [e809286]:
- effect@3.6.8
- @effect/experimental@0.23.7
- @effect/platform@0.62.5
- @effect/schema@0.71.4

0.9.6

Patch Changes

Updated dependencies [e7a65e3, 50ec889]:
- @effect/platform@0.62.4
- effect@3.6.7
- @effect/experimental@0.23.6
- @effect/schema@0.71.3

0.9.5

Patch Changes

Updated dependencies [f960bf4, 46a575f]:
- effect@3.6.6
- @effect/experimental@0.23.5
- @effect/platform@0.62.3
- @effect/schema@0.71.2

0.9.4

Patch Changes

#3483 35be739 Thanks @tim-smart! - infer Model repository id schema from id column name
#3480 f8326cc Thanks @tim-smart! - add Model.makeDataLoaders, for deriving CRUD data loaders
#3488 8dd3959 Thanks @tim-smart! - move VariantSchema.extract to factory, and copy type level behaviour
#3477 2cb6ebb Thanks @tim-smart! - update Model docs categories
#3476 5e9f51e Thanks @tim-smart! - add Model.FieldOption, for optional fields that are nullable for the db
#3479 83a108a Thanks @tim-smart! - add Model.makeRepository, for deriving a simple CRUD repo
#3493 f2c8dbb Thanks @tim-smart! - add VariantSchema.Union constructor
#3476 5e9f51e Thanks @tim-smart! - add Model.Date, a schema which represents a DateTime.Utc without time
Updated dependencies [00670d0, 413994c, 14a47a8, 0c09841, 8dd3959, dba570a, f2c8dbb, da52556]:
- @effect/experimental@0.23.4
- @effect/platform@0.62.2
- effect@3.6.5
- @effect/schema@0.71.1

0.9.3

Patch Changes

#3471 c3446d3 Thanks @tim-smart! - guard against stale values in Model.DateTime fields
Updated dependencies [c3446d3, 9efe0e5]:
- @effect/experimental@0.23.3
- @effect/platform@0.62.1

0.9.2

Patch Changes

#3467 cfcfbdf Thanks @tim-smart! - add VariantSchema.fields for accessing the fields
Updated dependencies [cfcfbdf]:
- @effect/experimental@0.23.2

0.9.1

Patch Changes

#3455 e9da539 Thanks @tim-smart! - add Model module to /sql

The Model module can be used to create domain schemas with common variants for the database and serializing to JSON.

import { Schema } from "@effect/schema"
import { Model } from "@effect/sql"

export const GroupId = Schema.Number.pipe(Schema.brand("GroupId"))

export class Group extends Model.Class<Group>("Group")({
  id: Model.Generated(GroupId),
  name: Schema.NonEmptyTrimmedString,
  createdAt: Model.DateTimeInsertFromDate,
  updatedAt: Model.DateTimeUpdateFromDate
}) {}

// schema used for selects
Group

// schema used for inserts
Group.insert

// schema used for updates
Group.update

// schema used for json api
Group.json
Group.jsonCreate
Group.jsonUpdate

// you can also turn them into classes
class GroupJson extends Schema.Class<GroupJson>("GroupJson")(Group.json) {
  get upperName() {
    return this.name.toUpperCase()
  }
}

#3460 4fabf75 Thanks @tim-smart! - support partial objects in sql helpers
Updated dependencies [e9da539]:
- @effect/experimental@0.23.1

0.9.0

Minor Changes

#3457 a07990d Thanks @IMax153! - Add support for executing raw SQL queries with the underlying SQL client.

This is primarily useful when the SQL client returns special results for certain query types.

For example, because MySQL does not support the RETURNING clause, the mysql2 client will return a ResultSetHeader for INSERT, UPDATE, DELETE, and TRUNCATE operations.

To gain access to the raw results of a query, you can use the .raw property on the Statement:

import * as Effect from "effect/Effect"
import * as SqlClient from "@effect/sql/SqlClient"
import * as MysqlClient from "@effect/sql/MysqlClient"

const DatabaseLive = MysqlClient.layer({
  database: Config.succeed("database"),
  username: Config.succeed("root"),
  password: Config.succeed(Redacted.make("password"))
})

const program = Effect.gen(function* () {
  const sql = yield* SqlClient.SqlClient

  const result = yield* sql`INSERT INTO usernames VALUES ("Bob")`.raw

  console.log(result)
  /**
   * ResultSetHeader {
   *   fieldCount: 0,
   *   affectedRows: 1,
   *   insertId: 0,
   *   info: '',
   *   serverStatus: 2,
   *   warningStatus: 0,
   *   changedRows: 0
   * }
   */
})

program.pipe(Effect.provide(DatabaseLive), Effect.runPromise)

Patch Changes

Updated dependencies [c1987e2, 8295281, c940df6, 00b6c6d, 1ceed14, f8d95a6, 0e42a8f]:
- @effect/schema@0.71.0
- effect@3.6.4
- @effect/platform@0.62.0

0.8.7

Patch Changes

Updated dependencies [04adcac]:
- effect@3.6.3
- @effect/platform@0.61.8
- @effect/schema@0.70.4

0.8.6

Patch Changes

Updated dependencies [17245a4, 630d40e, 630d40e]:
- @effect/platform@0.61.7

0.8.5

Patch Changes

Updated dependencies [99ad841, d829b57, fd4b2f6]:
- @effect/schema@0.70.3
- @effect/platform@0.61.6
- effect@3.6.2

0.8.4

Patch Changes

Updated dependencies [056b710]:
- @effect/platform@0.61.5

0.8.3

Patch Changes

Updated dependencies [e7cb109]:
- @effect/platform@0.61.4

0.8.2

Patch Changes

Updated dependencies [510a34d, fb9f786, 45dbb9f]:
- effect@3.6.1
- @effect/platform@0.61.3
- @effect/schema@0.70.2

0.8.1

Patch Changes

Updated dependencies [3dce357, 657fc48]:
- @effect/schema@0.70.1
- @effect/platform@0.61.2

0.8.0

Minor Changes

#3387 42d0706 Thanks @tim-smart! - allow sql Statement transformers to be effectful

Patch Changes

Updated dependencies [11223bf]:
- @effect/platform@0.61.1

0.7.0

Patch Changes

Updated dependencies [1e0fe80, 8135294, cd255a4, 3845646, 2d09078, 4bce5a0, 4ddbff0, e74cc38, bb069b4, cd255a4, 7d02174]:
- effect@3.6.0
- @effect/schema@0.70.0
- @effect/platform@0.61.0

0.6.3

Patch Changes

Updated dependencies [7c0da50, 2fc0ff4, 6359644, f262665, 7f41e42, 9bbe7a6, f566fd1]:
- @effect/schema@0.69.3
- effect@3.5.9
- @effect/platform@0.60.3

0.6.2

Patch Changes

Updated dependencies [eb4d014, 1ba640c, c8c71bd, a26ce58, fc20f73]:
- @effect/platform@0.60.2
- effect@3.5.8
- @effect/schema@0.69.2

0.6.1

Patch Changes

Updated dependencies [f241154]:
- @effect/schema@0.69.1
- @effect/platform@0.60.1

0.6.0

Patch Changes

Updated dependencies [20807a4]:
- @effect/schema@0.69.0
- @effect/platform@0.60.0

0.5.3

Patch Changes

#3310 99bddcf Thanks @fubhy! - Added additional pure annotations to improve tree-shakeability
Updated dependencies [3afcc93, 99bddcf, 6921c4f]:
- effect@3.5.7
- @effect/platform@0.59.3
- @effect/schema@0.68.27

0.5.2

Patch Changes

Updated dependencies [f0285d3, 8ec4955, 3ac2d76, cc327a1, 4bfe4fb, 2b14d18]:
- @effect/schema@0.68.26
- effect@3.5.6
- @effect/platform@0.59.2

0.5.1

Patch Changes

Updated dependencies [a9d7800, fcecff7, adbf753, adbf753]:
- effect@3.5.5
- @effect/platform@0.59.1
- @effect/schema@0.68.25

0.5.0

Minor Changes

#3260 53c0db0 Thanks @tim-smart! - replace /platform RefailError with use of the "cause" property

Patch Changes

Updated dependencies [53c0db0, ed0dde4, ada68b3, ca775ce, 5be9cc0, 203658f, eb1c4d4]:
- @effect/platform@0.59.0
- effect@3.5.4
- @effect/schema@0.68.24

0.4.27

Patch Changes

Updated dependencies [edb0da3, edb0da3, a1db40a, c8d3fb0, dabd028, 786b2ab, fc57354]:
- effect@3.5.3
- @effect/schema@0.68.23
- @effect/platform@0.58.27

0.4.26

Patch Changes

Updated dependencies [639208e, 6684b4c, 6684b4c, 6684b4c]:
- effect@3.5.2
- @effect/platform@0.58.26
- @effect/schema@0.68.22

0.4.25

Patch Changes

Updated dependencies [0623fca]:
- @effect/platform@0.58.25

0.4.24

Patch Changes

Updated dependencies [55fdd76]:
- effect@3.5.1
- @effect/platform@0.58.24
- @effect/schema@0.68.21

0.4.23

Patch Changes

Updated dependencies [a1f5b83, a1f5b83, a1f5b83, 60bc3d0, 5ab348f, 60bc3d0, 3e04bf8, e7fc45f, a1f5b83, 4626de5, f01e7db, 60bc3d0, 79d2d91, ac71f37, 8432360, e4bf1bf, 13cb861, 79d2d91, e7fc45f, 9f66825]:
- effect@3.5.0
- @effect/platform@0.58.23
- @effect/schema@0.68.20

0.4.22

Patch Changes

Updated dependencies [7af137c, ee4b3dc, 366f2ee, 366f2ee, 097d25c]:
- effect@3.4.9
- @effect/platform@0.58.22
- @effect/schema@0.68.19

0.4.21

Patch Changes

Updated dependencies [5d5cc6c, a435e0f, b5554db, 359ff8a, a9c4fb3, f7534b9]:
- @effect/schema@0.68.18
- effect@3.4.8
- @effect/platform@0.58.21

0.4.20

Patch Changes

Updated dependencies [15967cf, 2328e17, a5737d6]:
- @effect/schema@0.68.17
- effect@3.4.7
- @effect/platform@0.58.20

0.4.19

Patch Changes

Updated dependencies [d006cec, cb22726, e911cfd]:
- @effect/schema@0.68.16
- @effect/platform@0.58.19

0.4.18

Patch Changes

Updated dependencies [7f8900a]:
- @effect/platform@0.58.18

0.4.17

Patch Changes

Updated dependencies [5c0ceb0, 5c0ceb0, 34faeb6, 33735b1, 5c0ceb0, 139d4b3]:
- effect@3.4.6
- @effect/schema@0.68.15
- @effect/platform@0.58.17

0.4.16

Patch Changes

Updated dependencies [61e5964]:
- @effect/schema@0.68.14
- @effect/platform@0.58.16

0.4.15

Patch Changes

Updated dependencies [cb76bcb, baa90df]:
- @effect/schema@0.68.13
- @effect/platform@0.58.15

0.4.14

Patch Changes

Updated dependencies [52a87c7, 6d2280e]:
- @effect/platform@0.58.14

0.4.13

Patch Changes

Updated dependencies [a047af9, dbd53ea, d990544]:
- effect@3.4.5
- @effect/platform@0.58.13
- @effect/schema@0.68.12

0.4.12

Patch Changes

Updated dependencies [74e0ad2, 74e0ad2, 72638e3, d7dde2b, 9b2fc3b, d71c192]:
- @effect/platform@0.58.12
- effect@3.4.4
- @effect/schema@0.68.11

0.4.11

Patch Changes

Updated dependencies [a5b95b5, 5e29579]:
- @effect/platform@0.58.11

0.4.10

Patch Changes

#3079 bbdd365 Thanks @tim-smart! - update dependencies
#3079 bbdd365 Thanks @tim-smart! - update to typescript 5.5
Updated dependencies [a48ee84, c342739, 8898e5e, a48ee84, a48ee84, ff78636, c86bd4e, bbdd365, ab3180f, bbdd365]:
- @effect/platform@0.58.10
- effect@3.4.3
- @effect/schema@0.68.10

0.4.9

Patch Changes

Updated dependencies [0b47fdf]:
- @effect/schema@0.68.9
- @effect/platform@0.58.9

0.4.8

Patch Changes

Updated dependencies [192261b, 3da1497]:
- @effect/schema@0.68.8
- effect@3.4.2
- @effect/platform@0.58.8

0.4.7

Patch Changes

Updated dependencies [027004a]:
- @effect/platform@0.58.7

0.4.6

Patch Changes

Updated dependencies [66a1910, 2e8e252]:
- effect@3.4.1
- @effect/platform@0.58.6
- @effect/schema@0.68.7

0.4.5

Patch Changes

Updated dependencies [37a07a2]:
- @effect/platform@0.58.5

0.4.4

Patch Changes

Updated dependencies [b77fb0a]:
- @effect/platform@0.58.4

0.4.3

Patch Changes

Updated dependencies [530fa9e]:
- @effect/schema@0.68.6
- @effect/platform@0.58.3

0.4.2

Patch Changes

Updated dependencies [1d62815]:
- @effect/schema@0.68.5
- @effect/platform@0.58.2

0.4.1

Patch Changes

Updated dependencies [5a248aa]:
- @effect/platform@0.58.1

0.4.0

Minor Changes

#3035 d33d8b0 Thanks @tim-smart! - restructure sql modules to have flat imports

Patch Changes

Updated dependencies [c0ce180, 63dd0c3, 61707b6, 9c1b5b3, a35faf8, ff73c0c, 984d516, 8c3b8a2, 017e2f9, 91bf8a2, c6a4a26]:
- effect@3.4.0
- @effect/platform@0.58.0
- @effect/schema@0.68.4

0.3.18

Patch Changes

Updated dependencies [3ba7ea1]:
- @effect/platform@0.57.8

0.3.17

Patch Changes

Updated dependencies [d473800]:
- @effect/schema@0.68.3
- @effect/platform@0.57.7

0.3.16

Patch Changes

Updated dependencies [eb341b3]:
- @effect/schema@0.68.2
- @effect/platform@0.57.6

0.3.15

Patch Changes

Updated dependencies [b8ea6aa]:
- @effect/platform@0.57.5

0.3.14

Patch Changes

Updated dependencies [b51e266, 6c89408]:
- @effect/schema@0.68.1
- effect@3.3.5
- @effect/platform@0.57.4

0.3.13

Patch Changes

Updated dependencies [f6c7977, a67b8fe]:
- @effect/schema@0.68.0
- effect@3.3.4
- @effect/platform@0.57.3

0.3.12

Patch Changes

Updated dependencies [3b15e1b, 06ede85, 3a750b2, 7204ca5]:
- @effect/schema@0.67.24
- effect@3.3.3
- @effect/platform@0.57.2

0.3.11

Patch Changes

Updated dependencies [2ee4f2b, 07e12ec, 3572646, 1aed347, df4bf4b, f085f92, 9b3b4ac]:
- @effect/schema@0.67.23
- @effect/platform@0.57.1
- effect@3.3.2

0.3.10

Patch Changes

Updated dependencies [eb98c5b, 184fed8, 4d3fbe8, 6068e07, 3a77e20, d79ca17]:
- effect@3.3.1
- @effect/platform@0.57.0
- @effect/schema@0.67.22

0.3.9

Patch Changes

Updated dependencies [2b9ddfc, 1f4ac00, 9305b76, 0f40d98, 188f0a5, b761ef0, b53f69b, 0f40d98, 5bd549e, 67f160a, 67f160a]:
- @effect/platform@0.56.0
- effect@3.3.0
- @effect/schema@0.67.21

0.3.8

Patch Changes

Updated dependencies [4c6bc7f, a67d602]:
- @effect/schema@0.67.20
- @effect/platform@0.55.7

0.3.7

Patch Changes

Updated dependencies [8c5d280, 6ba6d26, cd7496b, 3f28bf2, 5817820, 349a036, 799aa20]:
- effect@3.2.9
- @effect/schema@0.67.19
- @effect/platform@0.55.6

0.3.6

Patch Changes

Updated dependencies [a0dd1c1]:
- @effect/schema@0.67.18
- @effect/platform@0.55.5

0.3.5

Patch Changes

Updated dependencies [d9d22e7, 3c080f7, 3c080f7, 7d6d875, 70cda70, fb91f17]:
- @effect/schema@0.67.17
- effect@3.2.8
- @effect/platform@0.55.4

0.3.4

Patch Changes

Updated dependencies [5745886, 6801fca]:
- @effect/schema@0.67.16
- effect@3.2.7
- @effect/platform@0.55.3

0.3.3

Patch Changes

Updated dependencies [2c2280b, e2740fc, cc8ac50, 60fe3d5]:
- @effect/platform@0.55.2
- @effect/schema@0.67.15
- effect@3.2.6

0.3.2

Patch Changes

#2867 3e86ced Thanks @jamiehodge! - fix sql mysql migrator

0.3.1

Patch Changes

Updated dependencies [c5846e9]:
- @effect/schema@0.67.14
- @effect/platform@0.55.1

0.3.0

Minor Changes

#2833 af0543c Thanks @tim-smart! - remove file system migrator from web sql implementations

Patch Changes

Updated dependencies [608b01f, 031c712, a44e532, 5133ca9]:
- effect@3.2.5
- @effect/platform@0.55.0
- @effect/schema@0.67.13

0.2.17

Patch Changes

Updated dependencies [1af94df, 1af94df, f8038ca, e376641, c07e0ce, e313a01, 1af94df]:
- effect@3.2.4
- @effect/platform@0.54.0
- @effect/schema@0.67.12

0.2.16

Patch Changes

Updated dependencies [5af633e, 45578e8]:
- @effect/schema@0.67.11
- effect@3.2.3
- @effect/platform@0.53.14

0.2.15

Patch Changes

Updated dependencies [5d9266e, 9f8122e, 6a6f670, c1eaef9, 78ffc27]:
- effect@3.2.2
- @effect/platform@0.53.13
- @effect/schema@0.67.10

0.2.14

Patch Changes

Updated dependencies [5432fff]:
- @effect/schema@0.67.9
- @effect/platform@0.53.12

0.2.13

Patch Changes

Updated dependencies [c1e991d]:
- effect@3.2.1
- @effect/platform@0.53.11
- @effect/schema@0.67.8

0.2.12

Patch Changes

#2778 7135748 Thanks @tim-smart! - capture stack trace for tracing spans
Updated dependencies [146cadd, 7135748, 7135748, 963b4e7, 64c9414, 7135748, 2cbb76b, 870c5fa, 146cadd, 7135748, 64c9414]:
- effect@3.2.0
- @effect/platform@0.53.10
- @effect/schema@0.67.7

0.2.11

Patch Changes

Updated dependencies [17da864, 17fc22e, 810f222, 596aaea, ff0efa0]:
- @effect/schema@0.67.6
- @effect/platform@0.53.9
- effect@3.1.6

0.2.10

Patch Changes

Updated dependencies [9c514de]:
- @effect/schema@0.67.5
- @effect/platform@0.53.8

0.2.9

Patch Changes

#2712 01b4553 Thanks @vecerek! - Use constants from @opentelemetry/semantic-conventions as span attribute names instead of hard-coded values
Updated dependencies [ee08593, da6d7d8]:
- @effect/schema@0.67.4
- @effect/platform@0.53.7

0.2.8

Patch Changes

Updated dependencies [6ac4847, 6ac4847]:
- @effect/platform@0.53.6
- effect@3.1.5
- @effect/schema@0.67.3

0.2.7

Patch Changes

Updated dependencies [89a3afb, 992c8e2]:
- @effect/schema@0.67.2
- @effect/platform@0.53.5

0.2.6

Patch Changes

Updated dependencies [e41e911]:
- effect@3.1.4
- @effect/platform@0.53.4
- @effect/schema@0.67.1

0.2.5

Patch Changes

Updated dependencies [d7e4997]:
- @effect/schema@0.67.0
- @effect/platform@0.53.3

0.2.4

Patch Changes

Updated dependencies [1f6dc96]:
- effect@3.1.3
- @effect/platform@0.53.2
- @effect/schema@0.66.16

0.2.3

Patch Changes

Updated dependencies [121d6d9]:
- @effect/schema@0.66.15
- @effect/platform@0.53.1

0.2.2

Patch Changes

Updated dependencies [d57fbbb]:
- @effect/platform@0.53.0

0.2.1

Patch Changes

Updated dependencies [5866c62]:
- @effect/platform@0.52.3

0.2.0

Minor Changes

#2693 0724274 Thanks @tim-smart! - make @effect/sql dialect agnostic

All of the client implementations now share the same Context.Tag. This means you can create services that support multiple SQL flavors.

You can now use the @effect/sql package to access the client apis:

import * as Sql from "@effect/sql"
import { Effect } from "effect"

Effect.gen(function* () {
  const sql = yield* Sql.client.Client
  yield* sql`SELECT * FROM users`
})

If you need a functionality that is specific to a implementation, you can use the tag from the implementation package:

import * as Sqlite from "@effect/sql-sqlite-node"
import { Effect } from "effect"

Effect.gen(function* () {
  const sql = yield* Sqlite.client.SqliteClient
  const dump = yield* sql.export
})

If you need to run a different query depending on the dialect, you can use the sql.onDialect api:

import * as Sql from "@effect/sql"
import { Effect } from "effect"

Effect.gen(function* () {
  const sql = yield* Sql.client.Client
  yield* sql.onDialect({
    sqlite: () => sql`SELECT * FROM sqlite_master`,
    mysql: () => sql`SHOW TABLES`,
    mssql: () => sql`SELECT * FROM sys.tables`,
    pg: () => sql`SELECT * FROM pg_catalog.pg_tables`
  })
})

Patch Changes

#2693 0724274 Thanks @tim-smart! - add .returning helper to insert and update apis

0.1.17

Patch Changes

#2679 2e1cdf6 Thanks @tim-smart! - ensure all type ids are annotated with unique symbol
#2685 d3cf2d8 Thanks @giacomoran! - fix sql.update default arguments
#2684 56ec8dd Thanks @giacomoran! - fix placeholder count in sql helpers
Updated dependencies [2e1cdf6]:
- @effect/platform@0.52.2
- effect@3.1.2
- @effect/schema@0.66.14

0.1.16

Patch Changes

Updated dependencies [e5e56d1]:
- effect@3.1.1
- @effect/platform@0.52.1
- @effect/schema@0.66.13

0.1.15

Patch Changes

Updated dependencies [9deab0a, 7719b8a]:
- @effect/platform@0.52.0

0.1.14

Patch Changes

#2543 a023f28 Thanks @github-actions! - set span kind where applicable
Updated dependencies [c3c12c6, ba64ea6, b5de2d2, a1c7ab8, a023f28, 0ec93cb, 1c9454d, a023f28, 92d56db]:
- effect@3.1.0
- @effect/platform@0.51.0
- @effect/schema@0.66.12

0.1.13

Patch Changes

Updated dependencies [16039a0, 557707b, d1d33e1, f4ed306, 661004f, e79cb83]:
- @effect/platform@0.50.8
- effect@3.0.8
- @effect/schema@0.66.11

0.1.12

Patch Changes

Updated dependencies [18de56b]:
- effect@3.0.7
- @effect/platform@0.50.7
- @effect/schema@0.66.10

0.1.11

Patch Changes

#2626 027418e Thanks @fubhy! - Reintroduce custom NoInfer type
#2621 f363af0 Thanks @tim-smart! - add sql transaction tracing spans
#2609 ac1898e Thanks @patroza! - change: BatchedRequestResolver works with NonEmptyArray
#2621 f363af0 Thanks @tim-smart! - update sql span attributes to follow semantic conventions
#2621 f363af0 Thanks @tim-smart! - add sql....unprepared, to run a query without trying to PREPARE it
Updated dependencies [ffe4f4e, 027418e, ac1898e, ffe4f4e, 8206529]:
- effect@3.0.6
- @effect/schema@0.66.9
- @effect/platform@0.50.6

0.1.10

Patch Changes

Updated dependencies [6222404, 868ed2a]:
- effect@3.0.5
- @effect/platform@0.50.5
- @effect/schema@0.66.8

0.1.9

Patch Changes

Updated dependencies [dd41c6c, 9a24667]:
- @effect/schema@0.66.7
- effect@3.0.4
- @effect/platform@0.50.4

0.1.8

Patch Changes

Updated dependencies [9dfc156, 80271bd, b3b51a2, e4ba97d]:
- @effect/schema@0.66.6
- @effect/platform@0.50.3

0.1.7

Patch Changes

Updated dependencies [b3fe829, a58b7de, d90e8c3]:
- @effect/schema@0.66.5
- @effect/platform@0.50.2

0.1.6

Patch Changes

Updated dependencies [773b8e0]:
- @effect/schema@0.66.4
- @effect/platform@0.50.1

0.1.5

Patch Changes

Updated dependencies [6f38dff, a7b4b84, a3b0e6c, 6f38dff]:
- @effect/platform@0.50.0
- effect@3.0.3
- @effect/schema@0.66.3

0.1.4

Patch Changes

#2562 2cecdbd Thanks @fubhy! - Added provenance publishing
Updated dependencies [2cecdbd]:
- @effect/platform@0.49.4
- effect@3.0.2
- @effect/schema@0.66.2

0.1.3

Patch Changes

Updated dependencies [8d39d65]:
- @effect/platform@0.49.3

0.1.2

Patch Changes

Updated dependencies [5ef0a1a]:
- @effect/platform@0.49.2

0.1.1

Patch Changes

#2544 f838c15 Thanks @tim-smart! - support column names for sql.in helper
#2555 8edacca Thanks @tim-smart! - prevent use of Array as import name to solve bundler issues
Updated dependencies [3da0cfa, 570e8d8, b2b5d66, 87c5687, 8edacca]:
- effect@3.0.1
- @effect/schema@0.66.1
- @effect/platform@0.49.1

0.1.0

Minor Changes

#2104 1499974 Thanks @IMax153! - initial @effect/sql release
#2207 2fb7d9c Thanks @github-actions! - Release Effect 3.0 🎉

Patch Changes

#2529 78b767c Thanks @fubhy! - Renamed ReadonlyArray and ReadonlyRecord modules for better discoverability.
Updated dependencies [1b5f0c7, d50a652, 9aeae46, 9a3bd47, 6460414, cf69f46, cf69f46, e542371, be9d025, 78b767c, aa4a3b5, 1499974, 1b5f0c7, 5c2b561, 6c6087a, a18f594, 1499974, 2f96d93, 5a2314b, 25d74f8, 6c6087a, 271b79f, 1b5f0c7, 2fb7d9c, 53d1c2a, e7e1bbe, 10c169e, 6424181]:
- effect@3.0.0
- @effect/schema@0.66.0
- @effect/platform@0.49.0

Files

CHANGELOG.md

Latest commit

History

CHANGELOG.md

File metadata and controls

@effect/sql

0.18.10

Patch Changes

0.18.9

Patch Changes

0.18.8

Patch Changes

0.18.7

Patch Changes

0.18.6

Patch Changes

0.18.5

Patch Changes

0.18.4

Patch Changes

0.18.3

Patch Changes

0.18.2

Patch Changes

0.18.1

Patch Changes

0.18.0

Patch Changes

0.17.0

Minor Changes

0.16.6

Patch Changes

0.16.5

Patch Changes

0.16.4

Patch Changes

0.16.3

Patch Changes

0.16.2

Patch Changes

0.16.1

Patch Changes

0.16.0

Patch Changes

0.15.1

Patch Changes

0.15.0

Patch Changes

0.14.1

Patch Changes

0.14.0

Minor Changes

0.13.4

Patch Changes

0.13.3

Patch Changes

0.13.2

Patch Changes

0.13.1

Patch Changes

0.13.0

Patch Changes

0.12.6

Patch Changes

0.12.5

Patch Changes

0.12.4

Patch Changes

0.12.3

Patch Changes

0.12.2

Patch Changes

0.12.1

Patch Changes

0.12.0

Patch Changes

0.11.3

Patch Changes

0.11.2