OK here is the thing with data transfer handled by SQLite. It is not very elegant and KNIME should be able to handle in and out data for Python on its own - but as it stands this should work.
A lot of code is taken from this article:
kn_example_python_error_sqlite.knwf (54.0 KB)