Note
SQLPage lets you build web applications using SQL queries. If you know SQL, you can create complete web applications without spending time on traditional web development languages and frameworks.
Download for Windows, MacOS, or Linux
This is a bugfix release.
- Fix a bug where the form component would not display the right checked state in radio buttons and check boxes (#751)
- Fix a bug in the link component where the properties
view_link
,edit_link
, anddelete_link
had become incompatible with the mainlink
property. - Updated sqlparser to v0.53 which fixes parse errors when using some advanced SQL syntax
- adds support for SQLite's
UPDATE OR REPLACE
syntax - adds support for MSSQL's
JSON_ARRAY
andJSON_OBJECT
functions - adds support for PostgreSQL's
JSON_OBJECT(key : value)
andJSON_OBJECT(key VALUE value)
syntax - fixes the parsing of
true
andfalse
in Microsoft SQL Server (mssql): they are now correctly parsed as column names, not as boolean values, since mssql does not support boolean literals. This means you may have to replaceTRUE as some_property
with1 as some_property
in your SQL code when working with mssql.
- adds support for SQLite's
- When your SQL contains errors, the error message now displays the precise line(s) number(s) of your file that contain the error.