Let's draft these release notes in a way that's focused on the end-user experience. We'll highlight what new features and improvements mean for users interacting with the software. --- Hello everyone! We've been working hard to bring you a range of new features and improvements in this update. Here's what's new and how it benefits you: 1. **Database Enhancements:** - We now support the `MONEY` and `SMALLMONEY` types in MSSQL. If you're dealing with financial data, this makes your life easier. - Added math functions to the built-in SQLite database, which means you can perform more calculations directly in your queries without extra work. 2. **Migration Files:** - You can now create empty migration files directly from the command line using the `sqlpage create-migration` command. This simplifies setting up new database changes. 3. **New Component:** - Introducing the new modal component. This allows you to display content in a popup window, improving the user interface and experience. 4. **Chart Improvements:** - Bar charts now sort categories by name rather than by their first appearance. This makes cumulative bar charts easier to interpret, especially when some data points are missing. - Pie charts now accept numerical values passed as strings, making it more flexible to create these charts. 5. **Updates and Fixes:** - Updated Tabler to version 1.4 and Tabler Icons to version 3.34. You now have access to 19 new icons for your projects. - Enhanced file-based routing: Requests to `/xxx` will now redirect to `/xxx/` only if `/xxx/index.sql` exists, resulting in a more intuitive navigation experience. - Fixed an issue where SSO logins would fail over time due to key rotation by identity providers. Now, the system refreshes provider metadata periodically, ensuring smoother and more reliable logins. 6. **Single Sign-On (SSO) Improvements:** - We've added support for partially private sites with OIDC SSO. This means you can have both public and private pages in the same application. It’s now easier to create a login page that redirects to your OIDC provider. - SQLPage can now read custom claims from SSO tokens. This lets you configure your identity provider to include user-specific data (like roles or permissions) in the login token, enabling dynamic content tailored to the authenticated user. 7. **Bug Fixes:** - Fixed an issue with URL parameters during SSO login. Now, if an anonymous user visits a page with URL parameters and logs in, they’ll be correctly redirected to that page with all parameters intact. 8. **SQL Parser Updates:** - Added support for Postgres text search types (tsquery and tsvector). - Fixed parsing of LIMIT in subqueries and improved handling of JOIN precedence and Unicode identifiers. - Support for MySQL `MEMBER OF`, making it easier to work with JSON arrays. We hope these updates make your experience with SQLPage even better. As always, we appreciate your feedback and are here to help if you have any questions or run into issues. Happy querying! --- Hello everyone! We've been working hard to bring you a range of new features and improvements in this update. Here's what's new and how it benefits you: 1. **Database Enhancements:** - We now support the `MONEY` and `SMALLMONEY` types in MSSQL, which is handy if you're dealing with financial data. - Added math functions to the built-in SQLite database, allowing you to perform more calculations directly in your queries. 2. **Migration Files:** - You can now create empty migration files directly from the command line using the `sqlpage create-migration` command, making it easier to set up new database changes. 3. **New Component:** - Introducing the new modal component. This allows you to display content in a popup window, improving the user interface and experience. 4. **Chart Improvements:** - Bar charts now sort categories by name rather than by their first appearance. This makes cumulative bar charts easier to interpret, especially when some data points are missing. - Pie charts now accept numerical values passed as strings, making it more flexible to create these charts. 5. **Updates and Fixes:** - Updated Tabler to version 1.4 and Tabler Icons to version 3.34, giving you access to 19 new icons for your projects. - Enhanced file-based routing: Requests to `/xxx` will now redirect to `/xxx/` only if `/xxx/index.sql` exists, resulting in a more intuitive navigation experience. - Fixed an issue where SSO logins would fail over time due to key rotation by identity providers. Now, the system refreshes provider metadata periodically, ensuring smoother and more reliable logins. 6. **Single Sign-On (SSO) Improvements:** - We've added support for partially private sites with OIDC SSO. This means you can have both public and private pages in the same application. It’s now easier to create a login page that redirects to your OIDC provider. - SQLPage can now read custom claims from SSO tokens. This lets you configure your identity provider to include user-specific data (like roles or permissions) in the login token, enabling dynamic content tailored to the authenticated user. 7. **Bug Fixes:** - Fixed an issue with URL parameters during SSO login. Now, if an anonymous user visits a page with URL parameters and logs in, they’ll be correctly redirected to that page with all parameters intact. 8. **SQL Parser Updates:** - Added support for Postgres text search types (tsquery and tsvector). - Fixed parsing of LIMIT in subqueries and improved handling of JOIN precedence and Unicode identifiers. - Support for MySQL `MEMBER OF`, making it easier to work with JSON arrays. We hope these updates make your experience with SQLPage even better. As always, we appreciate your feedback and are here to help if you have any questions or run into issues. Happy querying!