v1.0.0

PL/PRQL v1.0.0

I am happy to announce the release of plprql v1.0.0! This version marks my commitment to production readiness, following six months of almost no reported errors.

Highlights

• Production Ready: After extensive real-world use, PL/PRQL is now considered stable.
• Dependencies: Upgraded prqlc from 0.12.2 to 0.13.0.
• Documentation: Improved installation guides and README.
• Many thanks to our new contributor @dependabot. You made more commits for this release than me.

This release incorporates a couple of small enhancements and tweaks that improve overall quality and maintainability. The functionality and public API remains the same as in v0.1.0.

What's Changed in v1.0.0

• Bump prqlc from 0.12.2 to 0.13.0 by @dependabot[bot] in #60
• Update docs by @kaspermarstal in #59
• Explicitly attribute AnyDatum to Supabase Inc by @kaspermarstal in #35
• Narrow down unsafe blocks by @kaspermarstal in #32
• prql_to_sql should return PlprqlResult by @kaspermarstal in #31
• Fix README quickstart example by @kaspermarstal in #29
• Fix package bash workflow by @kaspermarstal in #28
• Add quickstart installation guide and prerequisites to other installation guides by @kaspermarstal in #27
• Add metadata for publishing on crates.io by @kaspermarstal in #25
• Move Row and its associated IntoHeapTuple next to call_table_iterator where it is used by @kaspermarstal in #24
• Fix inconsistent naming of return_/call_ functions by @kaspermarstal in #23
• Update README with suggestions from Show HN post by @kaspermarstal in #22

Full Changelog: v0.1.0...v1.0.0

v0.1.0

We're pleased to announce the initial release of PL/PRQL v0.1.0. This PostgreSQL extension lets you write functions using PRQL, a query language that simplifies analytical queries and data manipulation.

We expect the extension to be feature complete. It does one thing and does it well. Looking ahead, we will fix bugs and enhance existing features based on your feedback, and package the extension for more operating systems, distributions, and package managers for PostgreSQL extensions.

Feature highlights

• PRQL Functions: YOU can now encapsulate complex SQL queries within PRQL functions. This feature is designed to improve the readability and maintainability of SQL code, especially beneficial for large analytical queries.

• PRQL Compiler: The prql_to_sql() function allows users to see the SQL statements generated by their PRQL code. This aids in understanding how PRQL translates into SQL and assists in debugging.

• Inline Execution: With the prql function, users have the capability to run PRQL code directly. This feature is particularly useful for quick prototyping and integrating custom queries into ORMs.

Getting Started

The README provides step-by-step instructions on how to install the extension from source. You can also use the attached .deb files to install the extension on Debian distributions.

Contributing

We welcome contributions to the PL/PRQL project. If you're interested in contributing, please open an issue or a PR. Your input helps us to improve PL/PRQL.

Acknowledgments

Our sincere thanks to the developers of PRQL, especially @max-sixty. Whether through PR reviews, bug reporting, or other suggestions improvements, your contributions are greatly appreciated.

Feedback

We encourage users to provide feedback or report issues via our GitHub Issues page. Your input will drive the continuous improvement of PL/PRQL.