> SQLPage is an open-source tool that turns SQL queries into interactive web > apps. > It's used to build advanced internal tools, dashboards, and public websites, > entirely in SQL. > > Check it out on [**sql-page.com**](https://sql-page.com)
Today, we released version 0.33, which opens new possibilities. In particular, building complex page layouts and custom REST APIs got easier. Here is a short overview of what's new. ## 🚀 Cleaner Routing **No more `.sql` clutter!** Now, access `page.sql` simply as `/page`. - Old: `https://example.com/page.sql` - New: `https://example.com/page` We are keeping full backward compatibility, so old `.sql` URLs still work. Cool URIs don't change. ## 🔗 Smarter API Calls SQLPage exposes a set of functions, that are executed on the backend before sending your queries to Postgres. One of them is [`sqlpage.fetch`](https://sql-page.com/functions.sql?function=fetch), that calls external APIs, and transmits the results to your database, letting you process it using [postgres-native json functions](https://sql-page.com/blog.sql?post=JSON%20in%20SQL%3A%20A%20Comprehensive%20Guide). We significantly improved it in this release. - **HTTP Basic Auth in `sqlpage.fetch`** → Authenticate API requests directly from SQL. - **Better error messages** when HTTP requests fail. - **Default headers**: No need to define `headers` on every query; SQLPage now sends default ones automatically. ## 🎛️ UI Upgrades - **Auto-submit forms** → There is now an option to apply filters instantly, no manual form submission needed. - **Dynamic dropdowns** → Load dropdown options from another SQL file. Build an item search UI with auto-complete in two SQL queries. - **Markdown in form descriptions** → Add rich, formatted help text inside forms. ## 🛠️ Advanced SQL Support - **PostgreSQL’s `INSERT…SELECT…RETURNING`** now works seamlessly. - **`overlaps` operator support** → Filter time-based data more easily. ## 🎨 **Polished Look & Feel** - **Upgraded charts & icons** with [ApexCharts v4.4.0](https://github.com/apexcharts/apexcharts.js/releases/tag/v4.4.0) & [Tabler Icons 3.30](https://tabler.io/changelog#/changelog/tabler-icons-3.30). - **Better table formatting** → Numbers auto-format based on user locale. --- 💡 **Ready to try it out?** Check out the [release notes](https://github.com/sqlpage/sqlpage/releases) and start building! 🤔 Not ready to download it ? Try it online on [editor.datapage.app](https://editor.datapage.app/)
