# 🌀 Airsequel 0.5 - Improved Spreadsheet UI, AI-Powered SQL Query Generation, and more!

**URL:** <https://discourse.elm-lang.org/t/airsequel-0-5-improved-spreadsheet-ui-ai-powered-sql-query-generation-and-more/9047>\
**Category:** Show and Tell\
**Created:** [April 3, 2023, 12:43pm UTC](https://discourse.elm-lang.org/t/airsequel-0-5-improved-spreadsheet-ui-ai-powered-sql-query-generation-and-more/9047 "2023-04-03T12:43:57Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![ad-si](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.elm-lang.org/ad-si/32/4713_2.png) [@ad-si](https://discourse.elm-lang.org/u/ad-si)\
**Post date:** [April 3, 2023, 12:43pm UTC](https://discourse.elm-lang.org/t/airsequel-0-5-improved-spreadsheet-ui-ai-powered-sql-query-generation-and-more/9047/1 "2023-04-03T12:43:58Z")

</div>

I’m excited to announce the release of [Airsequel 0.5](https://www.airsequel.com/)! 🎉

I’m posting this here, because our goal is to become the easiest to use backend for Elm apps. (Also, our complete frontend is written in Elm.) Check out the tutorial: [How to build a todo app with Airsequel and Elm](https://docs.airsequel.com/tutorials/how-to-build-a-todo-app-with-airsequel-and-elm)!

This is our biggest release yet with more than 500 commits! If you’ve been holding off trying out Airsequel, now is a good time to get your feet wet! 😁

Here are some of the highlights:

**Spreadsheet UI** :

- More column data types, including  
file, date, URL, color, phone, email, time, and more  
 ![2023-03-28t154614_landing_page copy.png](https://buttondown-attachments.s3.us-west-2.amazonaws.com/images/cd853713-470d-4a28-8e9c-74021d8cdccc.png)
- Re-order columns and tables and insert new columns in specific locations
- Export tables as CSV or JSON

**SQL Workbench** :

- AI-powered SQL query generation via OpenAI  
 ![Screenshot of AI prompt](https://buttondown-attachments.s3.us-west-2.amazonaws.com/images/be5786f9-95c8-47ad-b0a1-cafa0e83d2c2.png)
- Tabs for working on several SQL queries simultaneously
- Support for editing views
- Upgraded SQLite from version 3.38.5 to 3.41.0, adding support for `RIGHT` and `FULL OUTER JOIN` and the built-in `unhex()` function
- Enforcing SQLite’s foreign key constraints by default

**GraphQL API** :

- Support for requesting changed data with the `returning` keyword
- Support for more comparison operators: `neq`, `gt`, `gte`, `lt`, and `lte`

**Additional Settings** :

- Show separate tabs for “Tables” and “Views”
- Button to regenerate read-only ID
- “Template” database environment (can be cloned via its readonly URL)

For a full list of all changes, check out the [changelog](https://docs.airsequel.com/changelog)!

We also have a newsletter if you want to get to get any news right into your inbox: [Airsequel Updates • Buttondown](https://buttondown.email/Airsequel)

We’re committed to making Airsequel the best tool for working with SQLite databases and using the data in production, and version 0.5 is a significant step forward in that direction. I hope you’ll try out these new features and improvements and let me know what you think! 😊

---

<div class="post-metadata">

**Author:** ![dwayne](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.elm-lang.org/dwayne/32/5478_2.png) [@dwayne](https://discourse.elm-lang.org/u/dwayne)\
**Post date:** [April 3, 2023, 2:49pm UTC](https://discourse.elm-lang.org/t/airsequel-0-5-improved-spreadsheet-ui-ai-powered-sql-query-generation-and-more/9047/2 "2023-04-03T14:49:13Z")

</div>

These links in the todo app example lead to 404 pages:

- [https://github.com/Airsequel/Examples/blob/main/elm-simple-todo-app-enterprise/src/A\_List.elm](https://github.com/Airsequel/Examples/blob/main/elm-simple-todo-app-enterprise/src/A_List.elm)
- [https://github.com/Airsequel/Examples/tree/main/elm-simple-todo-app-enterprise/src](https://github.com/Airsequel/Examples/tree/main/elm-simple-todo-app-enterprise/src)

I think it should be:

- [Examples/A\_List.elm at main · Airsequel/Examples · GitHub](https://github.com/Airsequel/Examples/tree/main/elm-simple-todo-app/src/A_List.elm)
- [Examples/elm-simple-todo-app/src at main · Airsequel/Examples · GitHub](https://github.com/Airsequel/Examples/tree/main/elm-simple-todo-app/src)

---

<div class="post-metadata">

**Author:** ![ad-si](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.elm-lang.org/ad-si/32/4713_2.png) [@ad-si](https://discourse.elm-lang.org/u/ad-si)\
**Post date:** [April 3, 2023, 3:20pm UTC](https://discourse.elm-lang.org/t/airsequel-0-5-improved-spreadsheet-ui-ai-powered-sql-query-generation-and-more/9047/3 "2023-04-03T15:20:55Z")

</div>

Good catch and thanks for the heads up! I just fixed it! 😊

---

<div class="post-metadata">

**Author:** ![dirkbj](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.elm-lang.org/dirkbj/32/3162_2.png) [@dirkbj](https://discourse.elm-lang.org/u/dirkbj)\
**Post date:** [April 7, 2023, 3:57pm UTC](https://discourse.elm-lang.org/t/airsequel-0-5-improved-spreadsheet-ui-ai-powered-sql-query-generation-and-more/9047/4 "2023-04-07T15:57:56Z")

</div>

This is amazing. I love seeing how Elm is used in production. Thanks for sharing. 🙂

---

<div class="post-metadata">

**Author:** ![loicknuchel](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.elm-lang.org/loicknuchel/32/4177_2.png) [@loicknuchel](https://discourse.elm-lang.org/u/loicknuchel)\
**Post date:** [April 10, 2023, 11:42am UTC](https://discourse.elm-lang.org/t/airsequel-0-5-improved-spreadsheet-ui-ai-powered-sql-query-generation-and-more/9047/5 "2023-04-10T11:42:45Z")

</div>

Awesome!  
Well done @ad-si!  
I love seeing Airsequel evolve 😃

---

<div class="post-metadata">

**Author:** ![Erudition](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.elm-lang.org/erudition/32/1502_2.png) [@Erudition](https://discourse.elm-lang.org/u/Erudition)\
**Post date:** [April 10, 2023, 9:06pm UTC](https://discourse.elm-lang.org/t/airsequel-0-5-improved-spreadsheet-ui-ai-powered-sql-query-generation-and-more/9047/6 "2023-04-10T21:06:48Z")

</div>

Looks cool!

Does this run locally, or only in combination with the cloud service?

What is the license of the code? I can only use freedom-respecting software in my projects, but it’s really hard to tell if Airsequel is a [Free/Libre/Open](https://wiki.snowdrift.coop/about/why-flo) option from the current websites. I assume it’s proprietary?

---

<div class="post-metadata">

**Author:** ![ad-si](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.elm-lang.org/ad-si/32/4713_2.png) [@ad-si](https://discourse.elm-lang.org/u/ad-si)\
**Post date:** [April 10, 2023, 9:36pm UTC](https://discourse.elm-lang.org/t/airsequel-0-5-improved-spreadsheet-ui-ai-powered-sql-query-generation-and-more/9047/7 "2023-04-10T21:36:31Z")

</div>

> Looks cool!

Thank you! 😊

> Does this run locally, or only in combination with the cloud service?

Airsequel is (and will stay) a single binary. So I have distributed it to interested persons as a binary and as a Docker image in the past. However, it makes more sense to run it as a cloud service. You can see the available options here: [Airsequel](https://www.airsequel.com/pricing)

> What is the license of the code? I can only use freedom-respecting software in my projects, but it’s really hard to tell if Airsequel is a [Free/Libre/Open](https://wiki.snowdrift.coop/about/why-flo) option from the current websites. I assume it’s proprietary?

Yes, currently it is proprietary. However, it’s very important to us to guarantee your data sovereignty and to not lock you in. I.e. all customer data is stored in 2 SQLite databases (one for the main data and one for metadata). You can download those databases at any time and move them somewhere els or e.g. build your own backend for them.

But we’ve also been thinking about releasing everything under the AGPL license. However, no decision has been made yet and it would also take some time since we’d have to clean up the code first …

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex035/uploads/elm_lang/original/1X/50a05e53677a2c3b47776d7abd0f113eb50193a1.png) [@system](https://discourse.elm-lang.org/u/system)\
**Post date:** [April 20, 2023, 9:36pm UTC](https://discourse.elm-lang.org/t/airsequel-0-5-improved-spreadsheet-ui-ai-powered-sql-query-generation-and-more/9047/8 "2023-04-20T21:36:33Z")

</div>

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.