Keep up with SQLITE updates

Yikes. Didn't realize that. I'll check into this.

It seems even the latest 2018 Beta is using version 3.8.2...

Some thoughts and rational on this topic....below is a reference to the current select syntax tree where you can see WITH and CTE stuff that was added after 3.8.2. I'm no expert on CTE (basic intro below); but can see the power of having the ability to define materialized (intermediate) tables within the same select statement; A very powerful feature to add the FME workflows using InlineQuery. In my own workflows I have started to utilize sql lite files as a better intermediate (ODS of sorts) that kind of replaces what in the past we used .ffs files for since it allows dataset iteration through WHERE clause and Joiner.

We all know how integral sqlite is to mobile/embedded development (see reference below) so it would be nice to be able to replicate advanced queries used in application development inside of an FME workflow.

https://sqlite.org/syntax/select-stmt.html

https://www.red-gate.com/simple-talk/sql/t-sql-programming/sql-server-cte-basics/

https://github.com/yapstudios/YapDatabase/wiki/SQLite-version-(bundled-with-OS)

Hi @bo, @rwhittington,

The latest betas of FME 2018 have been updated to SQLite 3.20.1.