## PrefectHQ/prefect — prefect-sqlalchemy-0.5.2…prefect-sqlalchemy-0.5.3

_1147+ commits._

### Features
- **Add boolean flag execute_commit for SELECT statements (#18095)** (0851785)
- **Add deployment versioning docs (#17974)** (e18d4dc)
- **Adds support for `AND`ed related resources in queries and triggers (#18003)** (a54b1eb)
- **add aef index (#17981)** (6c30078)
- **Support `@staticmethod` and `@classmethod` flow entrypoints (#17976)** (7e40be9)
- **add parameter form docs (#17972)** (84a4964)
- **Add test covering `.with_options` when used with a `classmethod` flow (#17647)** (f74293e)
- **Add default result storage for work pools (#17953)** (800ea5d)
- **add logfire dep group for performance exploration (#17860)** (bc7f6b2)
- **add `parameters` validator to `DeploymentCreateFlowRun` (#17938)** (e8852a9)
- **Add cloud github app to docs (#17911)** (d72a57e)
- **Add vcs version types for Gitlab, Bitbucket, and Azure Devops (#17915)** (6c7632d)
- **Add smoke test for remote execution via `prefect-client` (#17920)** (ffe241d)
- **Add done callback prior to submitting (#17917)** (98417f6)
- **Add initial documentation for submitting workflows directly to dynamic infrastructure (#17861)** (01441af)
- **Add `with_options` implementation to `InfrastructureBoundFlow` (#17900)** (1f8ede9)
- **Add `submit` method to infrastructure bound flows (#17896)** (5d0f68d)
- **Add `@docker` decorator (#17878)** (cd2bf96)
- **Add global concurrency id to the create and update route for deployments (#17826)** (e543ef3)
- **Add infrastructure decorators (#17863)** (093237b)
- **Add deployment version info to `prefect deploy` (#17466)** (b3b7081)
- **feat: Add support for a new `resolve_futures_to_results` function (#17869)** (3a2a3c9)
- **Add CLI to configure Azure Blob Storage for a work pool (#17837)** (35d14bc)
- **Add CLI to configure GCS storage for a work pool (#17836)** (3bffc05)
- **Add `InfrastructureBoundFlow` class and `bind_flow_to_infrastructure` function (#17833)** (c8eb890)
- **Add `.submit` method to `BaseWorker` (#17828)** (c4992b5)
- **Add experimental bundle steps for Azure Blob Storage (#17825)** (d01b30e)
- **Add async interface for transactions (#17794)** (85e42e8)
- **update background tasks docs and add guide (#17783)** (291bb48)
- **Add update block document mutation (#17793)** (c0195a7)
- **update classifiers and matrix generation for integrations 3.13 support (#17791)** (d831d23)
- **Added support for embedding image in mail (#17790)** (5ebffe3)
- **Add GCS bundle upload and execute steps (#17781)** (1cfffaa)

### Fixes
- **Fix error in setup for client compatibility tests (#18100)** (0439679)
- **fix parsing for `PREFECT_TASK_DEFAULT_RETRY_DELAY_SECONDS` (#18043)** (27cccbf)
- **fix readme link (#17999)** (10cd426)
- **Fix generated work pool storage config for GCS (#18000)** (612751a)
- **fix regex for snowflake private keys (#17985)** (d8bec12)
- **fix: Specify project during Cloud Run provision (#17965)** (1c5064c)
- **[wip] fix dead-lock between `ConcurrentTaskRunner`, `wait_for`, and tag concurrency limits (#17943)** (9f71cac)
- **Fix links to Specify flow parameters section (#17942)** (07107c3)
- **Update `uv.lock` and fix ECS provisioner test errors (#17928)** (1b73766)
- **fix human friendly diff (#17927)** (8f86aae)
- **Fix errors in `task-run ls` CLI (#17903)** (28b55e7)
- **Fix warning log on events client reconnect (#17876)** (a91fe3f)
- **fix link to archived repo (#17831)** (c669d1e)
- **fix pyright errors (#17841)** (68833d3)
- **Fix null `Scheduling` case in Vertex worker (#17835)** (d22beb6)
- **Fix readiness_result type to match expected Process type (#17771)** (fedfe66)

### Backend
- **Run `prefect-client` smoke tests against local server (#18067)** (554a7b6)
- **Vendor `uuid7` implementation (#18046)** (95a0cce)
- **update `jsonschema` lower bound to 4.18+ (#18036)** (951cfc2)
- **Adds Google site verification tag to our docs (#18031)** (f6ede15)
- **Task worker hygiene (#18016)** (0318a6b)
- **make `RedisLockManager` picklable for ray/dask compat (#18018)** (8361f0c)
- **misc type fixes in `prefect-shell` (#18002)** (f9346cb)
- **Move generation hooks to pre-push (#18010)** (93b1002)
- **Disable `kopf` scanning for `prefect-kubernetes` observer (#18013)** (2f1e62e)
- **Bugfix: Scatterplot pagination (#18009)** (b47ad8e)
- **Update @prefecthq/prefect-design to version 2.14.25 (#18011)** (0dadc0b)
- **Refactor Kubernetes worker to reduce statefulness (#18004)** (ca4119e)
- **Uses UUIDv7 for the IDs of time-oriented objects (#18008)** (b6a186b)
- **Allow `flow.sumbit` to be non-blocking for some infrastructure types (#17992)** (7e7a187)
- **Update @prefecthq/prefect-ui-library to version 3.12.12 (#17998)** (efd760e)
- **Bugfix: Coalesce flow run start times with expected start times (#17997)** (eac7f62)
- **organize types (#17994)** (661452c)
- **catch `FileNotFoundError` in `find_uv_bin` (#17993)** (467b4c3)
- **Update `Runner` to use a long-lived `EventsClient` (#17986)** (6869a02)
- **Update @prefecthq/prefect-ui-library to version 3.12.11 (#17991)** (754f25a)
- **Parse docker image strings with digests (#17987)** (d7cb487)
- **use correct secret in websocket subscription (#17975)** (c158d3e)
- **Refactor `Runner` to receive cancellation signals via websocket (#17973)** (378fc4f)
- **Move version info inference to `apply()` (#17966)** (c80e444)
- **Downgrade log message for limiter to debug level (#17970)** (44b7aca)
- **Update @prefecthq/prefect-ui-library to version 3.12.10 (#17969)** (f3dc509)
- **[UI v2] feat: Adds block document create page (#17862)** (1829d81)
- **Run integration tests against `prefect-client` (#17967)** (6b626d4)
- **[UI v2] feat: Adds create block document rq mutation (#17859)** (95e26b0)
- **Remove `extra="forbid"` config on `WorkPoolStorageConfiguration` (#17960)** (5d6e0c6)
- **Update @prefecthq/prefect-ui-library to version 3.12.9 (#17959)** (5c2e15f)
- **remove unnecessary walrus (#17957)** (a17e3d0)
- **Remove future garbage collection warning (#17954)** (89121bb)
- **Remove flow run notifications (#17939)** (a82ec55)
- **Allow providing a commit sha to the `git_clone` pull step (#17933)** (4feb44e)
- **rm stray print from secrets_manager.py (#17842)** (f517be0)
- **handle heartbeat event in `wait_for_flow_run` (#17930)** (048218b)
- **Update @prefecthq/prefect-design to version 2.14.24 (#17919)** (cd10dc7)
- **Update @prefecthq/prefect-ui-library to version 3.12.8 (#17918)** (6ee6044)
- **Update @prefecthq/prefect-ui-library to version 3.12.7 (#17910)** (0ac350e)
- **Improve performance when converting `State` to an ORM model (#17908)** (c360cea)
- **Polishes the experience with inferring versioning (#17901)** (bcc4137)
- **Update @prefecthq/prefect-ui-library to version 3.12.6 (#17899)** (bd387c1)
- **Update @prefecthq/prefect-ui-library to version 3.12.5 (#17898)** (dd8aa67)
- **Update @prefecthq/prefect-ui-library to version 3.12.4 (#17897)** (6a71e2d)
- **Update @prefecthq/prefect-ui-library to version 3.12.3 (#17886)** (cf28283)
- **Link submitted flows to their parent flow (#17894)** (fc50862)
- **serve all tasks in a module (#17858)** (7d003a1)
- **Propagates the currently triggering event (if any) for composite triggers (#17854)** (3b9abd4)
- **Update @prefecthq/prefect-ui-library to version 3.12.2 (#17856)** (3eeee59)
- **Update `pydantic-settings` version pin (#17853)** (5535f4a)
- **move decorated function discovery out of the cli (#17840)** (72653ab)
- **Update @prefecthq/prefect-ui-library to version 3.12.1 (#17847)** (db4b7a3)
- **Update @prefecthq/prefect-design to version 2.14.23 (#17845)** (f3fd489)
- **Fixes `Runner` command handling for Windows (#17839)** (d867b71)
- **Clean up dbt integration docs (#17838)** (a9c19c0)
- **update sync/async example in `prefect-slack` (#17832)** (d90d684)
- **Update @prefecthq/prefect-design to version 2.14.22 (#17834)** (c54641f)
- **[UI v2] feat: Initial implementation of block document edit page. The… (#17796)** (e5698f1)
- **Avoid clobbering dev venv (#17800)** (413f215)
- **respect auth for websockets (#17741)** (3569b33)
- **update deployment and remote code storage docs (#17819)** (c094fa1)
- **Quickstart docs (#17726)** (23b833f)
- **use platform independent method in telemetry instrumentation (#17824)** (2289526)
- **Update `prefect:managed` docs (#17808)** (b2bae7f)
- **Avoid deleting runs where execution has been attempted or are past their scheduled start date (#17769)** (7ca0355)
- **Update @prefecthq/prefect-ui-library to version 3.12.0 (#17801)** (5ed658d)
- **Only prompt to save if file does not exist (#17519)** (b2c7489)
- **deprecate runner webserver machinery (#17775)** (5c6513a)
- **allow configuring `RecentDeploymentScheduler` loop interval (#17795)** (fdf69f2)
- **[UI v2] feat: Integrates BlockDocumentEditPage scaffold with router (#17777)** (8d04712)
- **Update @prefecthq/prefect-ui-library to version 3.11.55 (#17786)** (54f6fbb)
- **avoid unexpected pre-commit diffs from local to CI (#17779)** (fe1db33)
- **[UI v2] feat: Adds block_schemas RQ queries (#17774)** (1c599c5)
- **initial run state change dialog (#17704)** (9dc6961)
- **Remove `react-code-blocks` dependency (#17773)** (bf105bb)

### Docs
- **docs: Nginx sample config + note about client API key/auth string precedence (#17810)** (c9c018d)

### Chore
- **chore(deps-dev): bump the eslint group in /ui-v2 with 4 updates (#18102)** (85eaf65)
- **chore(deps-dev): bump vite from 6.3.4 to 6.3.5 in /ui (#18021)** (e919998)
- **chore(deps-dev): bump @vitejs/plugin-vue from 5.2.3 to 5.2.4 in /ui (#18022)** (e49a5a0)
- **chore(deps-dev): bump typescript-eslint from 8.31.1 to 8.32.0 in /ui-v2 in the eslint group (#18023)** (7f25bbd)
- **Chore: Update variable name validator to allow hyphens (#17995)** (15e90f7)
- **chore(deps-dev): bump vue-tsc from 2.2.8 to 2.2.10 in /ui (#17923)** (3232581)
- **chore(deps-dev): bump the eslint group in /ui-v2 with 3 updates (#17978)** (2e25bb5)
- **chore(deps): update packaging requirement from <24.3,>=21.3 to >=21.3,<25.1 (#17871)** (ff334f0)
- **chore(deps): update whenever requirement from <0.8.0,>=0.7.3 to >=0.7.3,<0.9.0 (#17962)** (0a3c0e4)
- **chore(deps): bump astral-sh/setup-uv from 5 to 6 (#17906)** (23b2c91)
- **chore(deps-dev): bump vite from 6.3.2 to 6.3.4 in /ui-v2 (#17950)** (09dc2d0)
- **chore(deps-dev): bump vite from 6.3.2 to 6.3.4 in /ui (#17949)** (7baf93f)
- **chore(deps-dev): bump the eslint group in /ui-v2 with 4 updates (#17925)** (df10951)
- **chore(deps): bump the ui-v2-dependencies group in /ui-v2 with 34 updates (#17873)** (562b964)
- **chore(deps-dev): bump the eslint group in /ui-v2 with 3 updates (#17872)** (1cc9f4e)
- **chore(deps-dev): bump vite from 6.2.3 to 6.2.6 in /ui (#17806)** (679b113)
- **chore(deps-dev): bump @vitejs/plugin-vue from 5.2.1 to 5.2.3 in /ui (#17652)** (0c719df)
- **chore(deps-dev): bump typescript from 5.8.2 to 5.8.3 in /ui (#17751)** (69bba0c)
- **chore(docs): add terraform example for deployment trigger (#17829)** (ffb2965)
- **chore(deps): bump the ui-v2-dependencies group in /ui-v2 with 35 updates (#17812)** (887dad6)
- **chore(deps-dev): bump typescript-eslint from 8.29.0 to 8.29.1 in /ui-v2 in the eslint group (#17811)** (d87a610)
- **chore: tool.versioningit.default-version (#17802)** (2afb788)
- **chore(deps-dev): bump vite from 6.2.5 to 6.2.6 in /ui-v2 (#17807)** (8d2a1c5)
- **chore(deps): bump @babel/runtime from 7.26.0 to 7.27.0 in /ui-v2 (#17770)** (990e781)

_Recap by [Repo Wrapped](https://repowrapped.com/gh/PrefectHQ/prefect?utm_source=github-action)._