This workflow shows a KNIME workflow with a number of database nodes that directly work inside a database. It uses the file-based "sqlite" database (the entire database is written to a file on the hard disk).
This is a companion discussion topic for the original entry at https://kni.me/w/VBroy6cfQoOE0lhi