SQLPage v0.33: Build Custom UIs, and now APIs — All in SQL!

> 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/)