How to show SQL syntax in Query Builder Preview?

Wappler General Need Help
, ,
1

Hi all, I am new to Wappler and currently going through the excellent tutorial by @Hyperbytes (thanks by the way, "coffee" is coming :slight_smile:).
As a former DB-engineer (SQL Server) there is one thing that irks me: in the tutorial the SQL preview in query builder always shows the proper ANSI syntax. That is: upper case keywords like SELECT, INNER JOIN, WHERE etc. and nicely formatted, like
SELECT *
FROM table
WHERE criteria
In my preview (Version 6.8.0) everything is in one continuous string and lower case:
select * from table where criteria

How can I make the preview look "correct"? I wasn't able to find any setting.
Any help is much appreciated.

2

Hi, welcome :slight_smile:

I think this is not a setting but rather an internal Wappler change that led to this different behavior. In that perspective, as an end-user you can't change that.

I believe there were some talks about this before and it was also explained why the change happened. I believe it's because before it was pseudo-SQL generation by Wappler and now it's a real SQL query preview as given by Knex - the underlying DB library.

3

Thank you for the quick response @Apple :slight_smile:

Too bad, but then I'll live with that ...