Python can be powerful when it is extended with some external APIs.

This example workspace (in the attached files shown below, shows the integration of FME with SQLite via Python and SQLite API. (Note that FME 2007 is needed)

The example requires pysqlite, which can be found here.

SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. It can be downloaded from here - http://sqlite.org/.

The workspace SQliteReaderTest.fmw contains a PythonCreator transformer with a Python script, which connects to a database (included into the archive), executes a select statement, analyses results and creates features. Then the workspace creates geometries from an attribute that keeps coordinates in the OGC WKT format. To use this script for other tables or databases simply replace the database and table name in the script.

SQLiteReader.fmw has more general reading capabilities - the script is included into 'Startup Python Script' parameter, and can be used multiple times in a workspace.