@effect/sql

Source

0.52.1

Patch Changes

#6758 ad4085e Thanks @tim-smart! - Correct the SQL combinator examples in the README.
Updated dependencies [e5dfd78, 7ccbd9c, 4b03605, b75724b, ab2af6d, 8a405fd, 3cc3c6e, 3d390f2, fcabf08, 8ee801d, 5859b37, 735d81b]:
- @effect/platform@0.97.1
- effect@3.22.1
- @effect/experimental@0.61.1

0.52.0

Patch Changes

Updated dependencies [fffdee0]:
- effect@3.22.0
- @effect/experimental@0.61.0
- @effect/platform@0.97.0

0.51.1

Patch Changes

#6110 0fac630 Thanks @mitre88! - fix: correct typos in source code (receive, separate)
Updated dependencies [74f3267, 518d0e3, c016642]:
- effect@3.21.2
- @effect/platform@0.96.1

0.51.0

Patch Changes

Updated dependencies [f7bb09b, bd7552a, ad1a7eb, 0d32048, 0d32048]:
- effect@3.21.0
- @effect/experimental@0.60.0
- @effect/platform@0.96.0

0.50.0

Patch Changes

Updated dependencies [fc82e81, 82996bc, 4d97a61, f6b0960, 8798a84]:
- effect@3.20.0
- @effect/experimental@0.59.0
- @effect/platform@0.95.0

0.49.0

Patch Changes

Updated dependencies [77eeb86, ff7053f, 287c32c]:
- effect@3.19.13
- @effect/platform@0.94.0
- @effect/experimental@0.58.0

0.48.6

Patch Changes

#5837 811852a Thanks @tim-smart! - support idempotent offers to PersistedQueue
Updated dependencies [811852a]:
- @effect/experimental@0.57.9

0.48.5

Patch Changes

#5824 019bf24 Thanks @tim-smart! - improve ordering guarantees for SqlPersistedQueue

0.48.4

Patch Changes

#5820 c379c45 Thanks @tim-smart! - ensure redis PersistedQueue removes stale pending items on reset
Updated dependencies [f03b8e5, c379c45]:
- effect@3.19.8
- @effect/experimental@0.57.7

0.48.3

Patch Changes

#5816 a9206ce Thanks @tim-smart! - add dynamic batch size to PersistedQueue based on pending takers
Updated dependencies [a9206ce]:
- @effect/experimental@0.57.6

0.48.2

Patch Changes

#5813 7ef13d3 Thanks @tim-smart! - fix SqlPersistedQueue batch size
Updated dependencies [7ef13d3]:
- effect@3.19.7

0.48.1

Patch Changes

#5808 7b23d9a Thanks @tim-smart! - add PersistedQueue module
Updated dependencies [7b23d9a]:
- @effect/experimental@0.57.5

0.48.0

Minor Changes

#5686 571025c Thanks @tim-smart! - allow any type to be used as sql parameters

Patch Changes

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

0.47.0

Patch Changes

Updated dependencies [3c15d5f, 3863fa8, 2a03c76, 24a1685]:
- effect@3.19.0
- @effect/platform@0.93.0
- @effect/experimental@0.57.0

0.46.0

Patch Changes

Updated dependencies [1c6ab74, 70fe803, c296e32, a098ddf]:
- effect@3.18.0
- @effect/platform@0.92.0
- @effect/experimental@0.56.0

0.45.0

Patch Changes

Updated dependencies [d4d86a8]:
- @effect/platform@0.91.0
- @effect/experimental@0.55.0

0.44.2

Patch Changes

#5397 0e46e24 Thanks @IMax153! - Avoid issues with ESM builds by removing dependency on @opentelemetry/semantic-conventions
Updated dependencies [8c7bb52, 0e46e24]:
- @effect/platform@0.90.4

0.44.1

Patch Changes

#5350 d0b5fd1 Thanks @tim-smart! - add Migrator.fromRecord api

0.44.0

Patch Changes

Updated dependencies [7813640]:
- @effect/platform@0.90.0
- @effect/experimental@0.54.0

0.43.0

Patch Changes

Updated dependencies [40c3c87, ed2c74a, 073a1b8, f382e99, e8c7ba5, 7e10415, e9bdece, 8d95eb0]:
- effect@3.17.0
- @effect/experimental@0.53.0
- @effect/platform@0.89.0

0.42.1

Patch Changes

#5238 9dc9269 Thanks @ilovedesert001! - Add error cause to the migration phase failure

0.42.0

Minor Changes

#5192 17a5ea8 Thanks @nikelborm! - Updated deprecated OTel Resource attributes names and values.

Many of the attributes have undergone the process of deprecation not once, but twice. Most of the constants holding attribute names have been renamed. These are minor changes.

Additionally, there were numerous changes to the attribute keys themselves. These changes can be considered major.

In the @opentelemetry/semantic-conventions package, new attributes having ongoing discussion about them are going through a process called incubation, until a consensus about their necessity and form is reached. Otel team recommends devs to copy them directly into their code. Luckily, it’s not necessary because all of the new attribute names and values came out of this process (some of them were changed again) and are now considered stable.

Reasoning for minor version bump

Package	Major attribute changes	Major value changes
Clickhouse client	`db.system` -> `db.system.name` `db.name` -> `db.namespace`
MsSQL client	`db.system` -> `db.system.name` `db.name` -> `db.namespace`	`mssql` -> `microsoft.sql_server`
MySQL client	`db.system` -> `db.system.name` `db.name` -> `db.namespace`
Pg client	`db.system` -> `db.system.name` `db.name` -> `db.namespace`
Bun SQLite client	`db.system` -> `db.system.name`
Node SQLite client	`db.system` -> `db.system.name`
React.Native SQLite client	`db.system` -> `db.system.name`
Wasm SQLite client	`db.system` -> `db.system.name`
SQLite Do client	`db.system` -> `db.system.name`
LibSQL client	`db.system` -> `db.system.name`
D1 client	`db.system` -> `db.system.name`
Kysely client	`db.statement` -> `db.query.text`
@effect/sql	`db.statement` -> `db.query.text` `db.operation` -> `db.operation.name`

Patch Changes

#5211 d25f22b Thanks @mattiamanzati! - Removed some unnecessary single-arg pipe calls
Updated dependencies [f5dfabf, 17a5ea8, d25f22b]:
- effect@3.16.14
- @effect/platform@0.88.1
- @effect/experimental@0.52.1

0.41.0

Patch Changes

Updated dependencies [27206d7, dbabf5e]:
- @effect/platform@0.88.0
- @effect/experimental@0.52.0

0.40.14

Patch Changes

Updated dependencies [c1c05a8, 81fe4a2]:
- effect@3.16.13
- @effect/experimental@0.51.14
- @effect/platform@0.87.13

0.40.13

Patch Changes

Updated dependencies [32ba77a, d5e25b2]:
- @effect/platform@0.87.12
- @effect/experimental@0.51.13

0.40.12

Patch Changes

Updated dependencies [001392b, 7bfb099]:
- @effect/platform@0.87.11
- @effect/experimental@0.51.12

0.40.11

Patch Changes

Updated dependencies [678318d, 678318d]:
- @effect/platform@0.87.10
- @effect/experimental@0.51.11

0.40.10

Patch Changes

Updated dependencies [54514a2]:
- @effect/platform@0.87.9
- @effect/experimental@0.51.10

0.40.9

Patch Changes

Updated dependencies [4ce4f82]:
- @effect/platform@0.87.8
- @effect/experimental@0.51.9

0.40.8

Patch Changes

Updated dependencies [a9b617f, 7e26e86]:
- @effect/platform@0.87.7
- @effect/experimental@0.51.8

0.40.7

Patch Changes

Updated dependencies [905da99]:
- effect@3.16.12
- @effect/experimental@0.51.7
- @effect/platform@0.87.6

0.40.6

Patch Changes

Updated dependencies [96c1292]:
- @effect/experimental@0.51.6

0.40.5

Patch Changes

Updated dependencies [2fd8676]:
- @effect/platform@0.87.5
- @effect/experimental@0.51.5

0.40.4

Patch Changes

Updated dependencies [e82a4fd]:
- @effect/platform@0.87.4
- @effect/experimental@0.51.4

0.40.3

Patch Changes

#5129 46c3216 Thanks @tim-smart! - relax SqlSchema/Resolver.void return type constraint to unknown
Updated dependencies [1b6e396]:
- @effect/platform@0.87.3
- @effect/experimental@0.51.3

0.40.2

Patch Changes

Updated dependencies [4fea68c, b927954, 99590a6, 6c3e24c]:
- @effect/platform@0.87.2
- effect@3.16.11
- @effect/experimental@0.51.2

0.40.1

Patch Changes

Updated dependencies [faad30e]:
- effect@3.16.10
- @effect/experimental@0.51.1
- @effect/platform@0.87.1

0.40.0

Patch Changes

Updated dependencies [b5bac9a]:
- @effect/platform@0.87.0
- @effect/experimental@0.51.0

0.39.0

Patch Changes

Updated dependencies [5137c70, c23d25c, 5137c70, 5137c70]:
- effect@3.16.9
- @effect/platform@0.86.0
- @effect/experimental@0.50.0

0.38.2

Patch Changes

Updated dependencies [914a191]:
- @effect/platform@0.85.2
- @effect/experimental@0.49.2

0.38.1

Patch Changes

Updated dependencies [8cb98d5, db2dd3c]:
- effect@3.16.8
- @effect/experimental@0.49.1
- @effect/platform@0.85.1

0.38.0

Patch Changes

Updated dependencies [93687dd, 93687dd, 93687dd]:
- @effect/platform@0.85.0
- @effect/experimental@0.49.0

0.37.12

Patch Changes

Updated dependencies [1bb0d8a]:
- effect@3.16.7
- @effect/experimental@0.48.12
- @effect/platform@0.84.11

0.37.11

Patch Changes

Updated dependencies [a5f7595, a02470c, bf369b2, f891d45]:
- effect@3.16.6
- @effect/platform@0.84.10
- @effect/experimental@0.48.11

0.37.10

Patch Changes

Updated dependencies [bf418ef]:
- effect@3.16.5
- @effect/experimental@0.48.10
- @effect/platform@0.84.9

0.37.9

Patch Changes

Updated dependencies [8b9db77]:
- @effect/platform@0.84.8
- @effect/experimental@0.48.9

0.37.8

Patch Changes

Updated dependencies [74ab9a0, 770008e]:
- effect@3.16.4
- @effect/experimental@0.48.8
- @effect/platform@0.84.7

0.37.7

Patch Changes

Updated dependencies [a2d57c9]:
- @effect/experimental@0.48.7

0.37.6

Patch Changes

Updated dependencies [ceea77a]:
- @effect/platform@0.84.6
- @effect/experimental@0.48.6

0.37.5

Patch Changes

Updated dependencies [ec52c6a]:
- @effect/platform@0.84.5
- @effect/experimental@0.48.5

0.37.4

Patch Changes

Updated dependencies [87722fc, 36217ee]:
- effect@3.16.3
- @effect/experimental@0.48.4
- @effect/platform@0.84.4

0.37.3

Patch Changes

Updated dependencies [ab7684f]:
- @effect/platform@0.84.3
- @effect/experimental@0.48.3

0.37.2

Patch Changes

Updated dependencies [0ddf148]:
- effect@3.16.2
- @effect/experimental@0.48.2
- @effect/platform@0.84.2

0.37.1

Patch Changes

Updated dependencies [71174d0, d615e6e]:
- @effect/platform@0.84.1
- effect@3.16.1
- @effect/experimental@0.48.1

0.37.0

Patch Changes

Updated dependencies [ee0bd5d, 5189800, 58bfeaa, 194d748, 918c9ea, 9198e6f, 2a370bf, 58ccb91, fd47834]:
- effect@3.16.0
- @effect/experimental@0.48.0
- @effect/platform@0.84.0

0.36.0

Patch Changes

Updated dependencies [5522520, cc5bb2b]:
- @effect/platform@0.83.0
- effect@3.15.5
- @effect/experimental@0.47.0

0.35.8

Patch Changes

Updated dependencies [0617b9d]:
- @effect/platform@0.82.8
- @effect/experimental@0.46.8

0.35.7

Patch Changes

Updated dependencies [f570554, 78047e8, c20b95a, 94ada43]:
- effect@3.15.4
- @effect/platform@0.82.7
- @effect/experimental@0.46.7

0.35.6

Patch Changes

Updated dependencies [618903b]:
- @effect/platform@0.82.6
- @effect/experimental@0.46.6

0.35.5

Patch Changes

Updated dependencies [7764a07, 4577f54, 30a0d9c]:
- @effect/platform@0.82.5
- effect@3.15.3
- @effect/experimental@0.46.5

0.35.4

Patch Changes

#4903 89657ac Thanks @andrephilipsson! - Fix sql transforms when executing multiple statements
Updated dependencies [d45e8a8, d13b68e]:
- @effect/platform@0.82.4
- @effect/experimental@0.46.4

0.35.3

Patch Changes

Updated dependencies [b8722b8, a328f4b]:
- effect@3.15.2
- @effect/platform@0.82.3
- @effect/experimental@0.46.3

0.35.2

Patch Changes

Updated dependencies [739a3d4]:
- @effect/platform@0.82.2
- @effect/experimental@0.46.2

0.35.1

Patch Changes

Updated dependencies [787ce70, 1269641, 1269641]:
- effect@3.15.1
- @effect/experimental@0.46.1
- @effect/platform@0.82.1

0.35.0

Patch Changes

Updated dependencies [c654595, d9f5dea, 49aa723, 74c14d0, e4f49b6, 6f02224, 1dcfd41, b21ab16, fcf1822, 0061dd1, 8421e6e, a9b3fb7, fa10f56]:
- effect@3.15.0
- @effect/platform@0.82.0
- @effect/experimental@0.46.0

0.34.1

Patch Changes

Updated dependencies [24a9ebb]:
- effect@3.14.22
- @effect/experimental@0.45.1
- @effect/platform@0.81.1

0.34.0

Patch Changes

Updated dependencies [672920f]:
- @effect/platform@0.81.0
- @effect/experimental@0.45.0

0.33.21

Patch Changes

Updated dependencies [2f3b7d4]:
- effect@3.14.21
- @effect/experimental@0.44.21
- @effect/platform@0.80.21

0.33.20

Patch Changes

Updated dependencies [17e2f30]:
- effect@3.14.20
- @effect/experimental@0.44.20
- @effect/platform@0.80.20

0.33.19

Patch Changes

Updated dependencies [056a910, e25e7bb, 3273d57]:
- effect@3.14.19
- @effect/platform@0.80.19
- @effect/experimental@0.44.19

0.33.18

Patch Changes

Updated dependencies [b1164d4]:
- effect@3.14.18
- @effect/experimental@0.44.18
- @effect/platform@0.80.18

0.33.17

Patch Changes

Updated dependencies [0b54681, 41a59d5]:
- effect@3.14.17
- @effect/experimental@0.44.17
- @effect/platform@0.80.17

0.33.16

Patch Changes

Updated dependencies [ee14444, f1c8583]:
- effect@3.14.16
- @effect/platform@0.80.16
- @effect/experimental@0.44.16

0.33.15

Patch Changes

Updated dependencies [239cc99, 8b6c947, c50a63b]:
- effect@3.14.15
- @effect/experimental@0.44.15
- @effect/platform@0.80.15

0.33.14

Patch Changes

Updated dependencies [6ed8d15]:
- effect@3.14.14
- @effect/experimental@0.44.14
- @effect/platform@0.80.14

0.33.13

Patch Changes

Updated dependencies [ee77788, 5fce6ba, 570e45f]:
- effect@3.14.13
- @effect/experimental@0.44.13
- @effect/platform@0.80.13

0.33.12

Patch Changes

Updated dependencies [c2ad9ee, 9c68654]:
- effect@3.14.12
- @effect/experimental@0.44.12
- @effect/platform@0.80.12

0.33.11

Patch Changes

Updated dependencies [e536127]:
- effect@3.14.11
- @effect/experimental@0.44.11
- @effect/platform@0.80.11

0.33.10

Patch Changes

Updated dependencies [bc7efa3]:
- effect@3.14.10
- @effect/experimental@0.44.10
- @effect/platform@0.80.10

0.33.9

Patch Changes

Updated dependencies [d78249f]:
- effect@3.14.9
- @effect/experimental@0.44.9
- @effect/platform@0.80.9

0.33.8

Patch Changes

Updated dependencies [b3a2d32]:
- effect@3.14.8
- @effect/experimental@0.44.8
- @effect/platform@0.80.8

0.33.7

Patch Changes

Updated dependencies [b542a4b]:
- effect@3.14.7
- @effect/experimental@0.44.7
- @effect/platform@0.80.7

0.33.6

Patch Changes

Updated dependencies [47618c1, 6077882]:
- effect@3.14.6
- @effect/experimental@0.44.6
- @effect/platform@0.80.6

0.33.5

Patch Changes

Updated dependencies [40dbfef, 85fba81, 5a5ebdd]:
- effect@3.14.5
- @effect/platform@0.80.5
- @effect/experimental@0.44.5

0.33.4

Patch Changes

Updated dependencies [e4ba2c6]:
- effect@3.14.4
- @effect/experimental@0.44.4
- @effect/platform@0.80.4

0.33.3

Patch Changes

Updated dependencies [37aa8e1, 34f03d6]:
- effect@3.14.3
- @effect/experimental@0.44.3
- @effect/platform@0.80.3

0.33.2

Patch Changes

Updated dependencies [f87991b, f87991b, 0a3e3e1]:
- effect@3.14.2
- @effect/experimental@0.44.2
- @effect/platform@0.80.2

0.33.1

Patch Changes

Updated dependencies [4a274fe]:
- effect@3.14.1
- @effect/experimental@0.44.1
- @effect/platform@0.80.1

0.33.0

Minor Changes

#4469 3131f8f Thanks @tim-smart! - refactor of @effect/cluster packages

Patch Changes

Updated dependencies [1f47e4e, 26dd75f, aba2d1d, 3131f8f, aba2d1d, 04dff2d, aba2d1d, c7fac0c, aba2d1d, ffaa3f3, ab957c1, 35db9ce, aba2d1d, cf77ea9, 26dd75f, baaab60]:
- effect@3.14.0
- @effect/experimental@0.44.0
- @effect/platform@0.80.0

0.32.4

Patch Changes

Updated dependencies [5662363, 5f1fd15, 8bb1460]:
- @effect/platform@0.79.4
- @effect/experimental@0.43.4

0.32.3

Patch Changes

Updated dependencies [0c4803f, 6f65ac4]:
- effect@3.13.12
- @effect/experimental@0.43.3
- @effect/platform@0.79.3

0.32.2

Patch Changes

Updated dependencies [fad8cca, 4296293, 9c241ab, 082b0c1, be12983, de88127]:
- effect@3.13.11
- @effect/experimental@0.43.2
- @effect/platform@0.79.2

0.32.1

Patch Changes

Updated dependencies [527c964]:
- effect@3.13.10
- @effect/experimental@0.43.1
- @effect/platform@0.79.1

0.32.0

Patch Changes

Updated dependencies [88fe129, d630249, 2976e52]:
- @effect/platform@0.79.0
- effect@3.13.9
- @effect/experimental@0.43.0

0.31.1

Patch Changes

Updated dependencies [c65d336, 22d2ebb]:
- effect@3.13.8
- @effect/experimental@0.42.1
- @effect/platform@0.78.1

0.31.0

Patch Changes

Updated dependencies [c5bcf53]:
- @effect/platform@0.78.0
- @effect/experimental@0.42.0

0.30.7

Patch Changes

Updated dependencies [840cc73, 9bf8a74, 87ba23c, f910880, 0d01480]:
- @effect/platform@0.77.7
- effect@3.13.7
- @effect/experimental@0.41.7

0.30.6

Patch Changes

Updated dependencies [3154ce4]:
- effect@3.13.6
- @effect/experimental@0.41.6
- @effect/platform@0.77.6

0.30.5

Patch Changes

Updated dependencies [367bb35, 6cf11c3, a0acec8]:
- effect@3.13.5
- @effect/experimental@0.41.5
- @effect/platform@0.77.5

0.30.4

Patch Changes

Updated dependencies [e0746f9, 17d9e89]:
- @effect/platform@0.77.4
- effect@3.13.4
- @effect/experimental@0.41.4

0.30.3

Patch Changes

Updated dependencies [cc5588d, 623c8cd, 00b4eb1, f2aee98, fb798eb, 2251b15, 2e15c1e, a4979db, b74255a, d7f6a5c, 9dd8979, 477b488, 10932cb, 9f6c784, 2c639ec, 886aaa8]:
- effect@3.13.3
- @effect/experimental@0.41.3
- @effect/platform@0.77.3

0.30.2

Patch Changes

Updated dependencies [31be72a, 3e7ce97, 31be72a]:
- effect@3.13.2
- @effect/platform@0.77.2
- @effect/experimental@0.41.2

0.30.1

Patch Changes

Updated dependencies [b56a211]:
- effect@3.13.1
- @effect/experimental@0.41.1
- @effect/platform@0.77.1

0.30.0

Patch Changes

Updated dependencies [8baef83, 655bfe2, d90cbc2, 75632bd, c874a2e, bf865e5, f98b2b7, de8ce92, cf8b2dd, db426a5, 6862444, 5fc8a90, 546a492, 65c4796, 9760fdc, 5b471e7, 4f810cc]:
- effect@3.13.0
- @effect/experimental@0.41.0
- @effect/platform@0.77.0

0.29.1

Patch Changes

Updated dependencies [4018eae, 543d36d, c407726, f70a65a, ba409f6, 3d2e356]:
- effect@3.12.12
- @effect/platform@0.76.1
- @effect/experimental@0.40.1

0.29.0

Patch Changes

Updated dependencies [b6a032f, 42ddd5f, 2fe447c, 2473ad5]:
- effect@3.12.11
- @effect/platform@0.76.0
- @effect/experimental@0.40.0

0.28.4

Patch Changes

Updated dependencies [e30f132, 33fa667, 87f5f28, 7d57ecd, 4dbd170]:
- effect@3.12.10
- @effect/platform@0.75.4
- @effect/experimental@0.39.4

0.28.3

Patch Changes

Updated dependencies [1b4a4e9]:
- effect@3.12.9
- @effect/experimental@0.39.3
- @effect/platform@0.75.3

0.28.2

Patch Changes

Updated dependencies [59b3cfb, 766113c, bb05fb8, 712277f, f269122, 8f6006a, c45b559, 430c846, 7b03057, a9c94c8, 107e6f0, c9175ae, 65c11b9, e386d2f, 9172efb]:
- @effect/platform@0.75.2
- effect@3.12.8
- @effect/experimental@0.39.2

0.28.1

Patch Changes

Updated dependencies [8dff1d1]:
- effect@3.12.7
- @effect/experimental@0.39.1
- @effect/platform@0.75.1

0.28.0

Patch Changes

Updated dependencies [5e43ce5, 289c13b, 76eb7d0, 8b4e75d, fc5e0f0, 004fd2b, b2a31be, 5514d05, bf5f0ae, 3b19bcf, b064b3b, eb264ed, 289c13b, f474678, ee187d0]:
- @effect/experimental@0.39.0
- @effect/platform@0.75.0
- effect@3.12.6

0.27.0

Patch Changes

#3978 bd0d489 Thanks @tim-smart! - improve defaults for VariantSchema.Overrideable
#3978 bd0d489 Thanks @tim-smart! - add experimental EventLog modules
Updated dependencies [bd0d489, a8b0ddb, 8653072, 507d546, a8b0ddb, 8db239b, 84a0911, 84a0911, 3179a9f, 6cb9b76, 1fcbe55, bd0d489, d9a63d9, 6cb9b76]:
- @effect/experimental@0.38.0
- effect@3.12.5
- @effect/platform@0.74.0

0.26.1

Patch Changes

Updated dependencies [5b50ea4, c170a68, a66c2eb, c9e5e1b, 7b3d58d]:
- effect@3.12.4
- @effect/platform@0.73.1
- @effect/experimental@0.37.1

0.26.0

Patch Changes

Updated dependencies [d7dac48, c110032, 1d7fd2b, 1d7fd2b, 23ac740, 8cd7319]:
- effect@3.12.3
- @effect/platform@0.73.0
- @effect/experimental@0.37.0

0.25.2

Patch Changes

Updated dependencies [734af82, b63c780, 212e784, f852cb0, 7276ae2, 212e784, 212e784, 212e784, c640d77, 0def088]:
- effect@3.12.2
- @effect/platform@0.72.2
- @effect/experimental@0.36.2

0.25.1

Patch Changes

Updated dependencies [302b57d, 0988083, 8b46be6, bfe8027, 16dd657, 39db211]:
- effect@3.12.1
- @effect/experimental@0.36.1
- @effect/platform@0.72.1

0.25.0

Patch Changes

Updated dependencies [abb22a4, f369a89, 642376c, 3d2b7a7, ef64c6f, 73f9c6f, 17cb451, d801820, e1eeb2d, c11f3a6, 618f7e0, c0ba834, e1eeb2d]:
- effect@3.12.0
- @effect/platform@0.72.0
- @effect/experimental@0.36.0

0.24.3

Patch Changes

Updated dependencies [39457d4, a475cc2, 199214e, b3c160d]:
- effect@3.11.10
- @effect/experimental@0.35.3
- @effect/platform@0.71.7

0.24.2

Patch Changes

Updated dependencies [1c08a0b, 1ce703b, 1ce703b]:
- effect@3.11.9
- @effect/experimental@0.35.2
- @effect/platform@0.71.6

0.24.1

Patch Changes

Updated dependencies [05d71f8, e66b920]:
- @effect/platform@0.71.5
- @effect/experimental@0.35.1

0.24.0

Patch Changes

Updated dependencies [909181a, 909181a, 1a6b52d]:
- @effect/platform@0.71.4
- effect@3.11.8
- @effect/experimental@0.35.0

0.23.3

Patch Changes

Updated dependencies [6984508, 883639c]:
- @effect/platform@0.71.3
- @effect/experimental@0.34.3

0.23.2

Patch Changes

Updated dependencies [2408616, cec0b4d, cec0b4d, 8d978c5, cec0b4d, cec0b4d]:
- effect@3.11.7
- @effect/platform@0.71.2
- @effect/experimental@0.34.2

0.23.1

Patch Changes

Updated dependencies [1d3df5b]:
- @effect/platform@0.71.1
- @effect/experimental@0.34.1

0.23.0

Patch Changes

Updated dependencies [662d1ce, c99a0f3, 11fc401, c99a0f3, 31c62d8]:
- effect@3.11.6
- @effect/platform@0.71.0
- @effect/experimental@0.34.0

0.22.7

Patch Changes

Updated dependencies [9f5a6f7, ef70ffc, 22905cf, 9f5a6f7, 1e59e4f, 9f5a6f7, 8d914e5, 03bb00f, 9f5a6f7, 14e1149, 9f5a6f7, 9f5a6f7]:
- effect@3.11.5
- @effect/experimental@0.33.7
- @effect/platform@0.70.7

0.22.6

Patch Changes

Updated dependencies [9a5b8e3]:
- @effect/platform@0.70.6
- @effect/experimental@0.33.6

0.22.5

Patch Changes

Updated dependencies [415f4c9, 518b258, 6e323a3, 518b258, 6e323a3]:
- @effect/platform@0.70.5
- effect@3.11.4
- @effect/experimental@0.33.5

0.22.4

Patch Changes

Updated dependencies [90906f7, 3862cd3, 3862cd3, 343b6aa, afba339]:
- effect@3.11.3
- @effect/experimental@0.33.4
- @effect/platform@0.70.4

0.22.3

Patch Changes

Updated dependencies [7044730]:
- @effect/platform@0.70.3
- @effect/experimental@0.33.3

0.22.2

Patch Changes

Updated dependencies [01cee56, c2249ea, 1358aa5, 1de3fe7]:
- effect@3.11.2
- @effect/platform@0.70.2
- @effect/experimental@0.33.2

0.22.1

Patch Changes

Updated dependencies [dd8a2d8, a71bfef]:
- effect@3.11.1
- @effect/experimental@0.33.1
- @effect/platform@0.70.1

0.22.0

Patch Changes

Updated dependencies [147434b, 6e69493, 147434b, 5eff3f6, d9fe79b, 251d189, 5a259f3, b4ce4ea, 15fcc5a, 9bc9a47, aadb8a4, 1e2747c, 9264162, e0b9b09, c36f3b9, 672bde5, aadb8a4]:
- effect@3.11.0
- @effect/platform@0.70.0
- @effect/experimental@0.33.0

0.21.4

Patch Changes

Updated dependencies [3069614, 09a5e52]:
- effect@3.10.20
- @effect/experimental@0.32.17
- @effect/platform@0.69.32

0.21.3

Patch Changes

Updated dependencies [e6d4a37]:
- @effect/platform@0.69.31
- @effect/experimental@0.32.16

0.21.2

Patch Changes

Updated dependencies [5e17400]:
- @effect/experimental@0.32.15

0.21.1

Patch Changes

Updated dependencies [270f199]:
- @effect/platform@0.69.30
- @effect/experimental@0.32.14

0.21.0

Minor Changes

#4022 1b1ba09 Thanks @tim-smart! - allow cloning a SqlClient with transforms disabled

Patch Changes

#4021 e9dfea3 Thanks @tim-smart! - add .reactive method to SqlClient interface
Updated dependencies [e9dfea3, 24cc35e]:
- @effect/experimental@0.32.13
- @effect/platform@0.69.29

0.20.12

Patch Changes

#4007 944025b Thanks @gcanti! - Wrap JSDoc @example tags with a TypeScript fence, closes #4002
Updated dependencies [edd72be, a3e2771, 944025b, 54addee, a9e00e4]:
- @effect/platform@0.69.28
- @effect/experimental@0.32.12
- effect@3.10.19

0.20.11

Patch Changes

Updated dependencies [af409cf, beaccae]:
- effect@3.10.18
- @effect/platform@0.69.27
- @effect/experimental@0.32.11

0.20.10

Patch Changes

Updated dependencies [c963886, 42c4ce6]:
- @effect/platform@0.69.26
- effect@3.10.17
- @effect/experimental@0.32.10

0.20.9

Patch Changes

Updated dependencies [320557a, 4dca30c, 1d99867, 6dae414, 6b0d737, d8356aa, 7b93dd6]:
- @effect/platform@0.69.25
- effect@3.10.16
- @effect/experimental@0.32.9

0.20.8

Patch Changes

Updated dependencies [3cc6514]:
- @effect/platform@0.69.24
- @effect/experimental@0.32.8

0.20.7

Patch Changes

Updated dependencies [3aff4d3]:
- @effect/platform@0.69.23
- @effect/experimental@0.32.7

0.20.6

Patch Changes

Updated dependencies [8398b32, 4e9e256, 72e55b7]:
- effect@3.10.15
- @effect/experimental@0.32.6
- @effect/platform@0.69.22

0.20.5

Patch Changes

Updated dependencies [f983946, 2d8a750]:
- effect@3.10.14
- @effect/experimental@0.32.5
- @effect/platform@0.69.21

0.20.4

Patch Changes

Updated dependencies [995bbdf]:
- effect@3.10.13
- @effect/experimental@0.32.4
- @effect/platform@0.69.20

0.20.3

Patch Changes

Updated dependencies [eb8c52d]:
- @effect/platform@0.69.19
- @effect/experimental@0.32.3

0.20.2

Patch Changes

Updated dependencies [a0584ec, dd14efe, dd14efe]:
- @effect/platform@0.69.18
- effect@3.10.12
- @effect/experimental@0.32.2

0.20.1

Patch Changes

Updated dependencies [5eef499, 8240b1c, 5eef499]:
- effect@3.10.11
- @effect/platform@0.69.17
- @effect/experimental@0.32.1

0.20.0

Patch Changes

Updated dependencies [12b3275]:
- @effect/experimental@0.32.0

0.19.0

Patch Changes

Updated dependencies [cd720ae, cd720ae, cd720ae, cd720ae, cd720ae, b631f40, 7d89650]:
- @effect/experimental@0.31.0
- effect@3.10.10
- @effect/platform@0.69.16

0.18.16

Patch Changes

Updated dependencies [8a30e1d]:
- @effect/platform@0.69.15
- @effect/experimental@0.30.16

0.18.15

Patch Changes

Updated dependencies [a123e80, bd5fcd3, 0289d3b, 7386b71, 07c493a, 257ab1b, 4211a23]:
- effect@3.10.9
- @effect/platform@0.69.14
- @effect/experimental@0.30.15

0.18.14

Patch Changes

Updated dependencies [6f86821, 68b5c9e, 9c9928d, 6306e66, 361c7f3]:
- @effect/experimental@0.30.14
- effect@3.10.8
- @effect/platform@0.69.13

0.18.13

Patch Changes

Updated dependencies [33f5b9f, 50f0281]:
- effect@3.10.7
- @effect/experimental@0.30.13
- @effect/platform@0.69.12

0.18.12

Patch Changes

Updated dependencies [ce1c21f, 81ddd45]:
- effect@3.10.6
- @effect/platform@0.69.11
- @effect/experimental@0.30.12

0.18.11

Patch Changes

Updated dependencies [3a6d757, 59d813a]:
- effect@3.10.5
- @effect/experimental@0.30.11
- @effect/platform@0.69.10

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:

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

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

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

14
console.log(
15
  Schema.encodeSync(User.json)({
16
    id: 1,
17
    firstName: "Bob"
18
  })
19
)
20
/*
21
{ id: 1, first_name: 'Bob' }
22
*/

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.

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

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

6
export class Group extends Model.Class<Group>("Group")({
7
  id: Model.Generated(GroupId),
8
  name: Schema.NonEmptyTrimmedString,
9
  createdAt: Model.DateTimeInsertFromDate,
10
  updatedAt: Model.DateTimeUpdateFromDate
11
}) {}
12

13
// schema used for selects
14
Group
15

16
// schema used for inserts
17
Group.insert
18

19
// schema used for updates
20
Group.update
21

22
// schema used for json api
23
Group.json
24
Group.jsonCreate
25
Group.jsonUpdate
26

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

#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:

1
import * as Effect from "effect/Effect"
2
import * as SqlClient from "@effect/sql/SqlClient"
3
import * as MysqlClient from "@effect/sql/MysqlClient"
4

5
const DatabaseLive = MysqlClient.layer({
6
  database: Config.succeed("database"),
7
  username: Config.succeed("root"),
8
  password: Config.succeed(Redacted.make("password"))
9
})
10

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

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

16
  console.log(result)
17
  /**
18
   * ResultSetHeader {
19
   *   fieldCount: 0,
20
   *   affectedRows: 1,
21
   *   insertId: 0,
22
   *   info: '',
23
   *   serverStatus: 2,
24
   *   warningStatus: 0,
25
   *   changedRows: 0
26
   * }
27
   */
28
})
29

30
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:

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

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

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

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

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

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

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

4
Effect.gen(function* () {
5
  const sql = yield* Sql.client.Client
6
  yield* sql.onDialect({
7
    sqlite: () => sql`SELECT * FROM sqlite_master`,
8
    mysql: () => sql`SHOW TABLES`,
9
    mssql: () => sql`SELECT * FROM sys.tables`,
10
    pg: () => sql`SELECT * FROM pg_catalog.pg_tables`
11
  })
12
})

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