SQLScout 5.0.0 Released

Changelog

• Added support for Android Studio 3.3.
• Updated SQLite JDBC driver to version 3.25.2. This version supports Sqlite’s UPSERT and window functions. Please note that the “Live Device Connection” feature does not use SQLScout’s embedded JDBC driver, but the SQLite engine in the Android device instead.
• SQL language support improvements:
  • SELECT statements are allowed inside functions.
    
  • Added support for parsing UPSERT clauses (UPSERT was added to SQLite 3.24.0).
    
  • Added support for parsing window functions (window functions were added to SQLite 3.25.0).
    
• SQL editor improvements:
  • Code completion offers binary operators when appropriate.
    
  • Code completion and syntax highlighting support for UPSERT clauses.
    
  • Code completion and syntax highlighting support for window functions.