IBM i Python cli Scripts with CL commands to query databases or insert, update delete individual records. These can be used on any platform including IBMi ... IBM i DB2, ODBC, SQLite, MariaDB, ...

I have written a python script that reads files one-by-one out of a blob storage account, reformat them into a data frame and then writes them to a SQL Server DB using SQL Alchemy for daily log files.

Create SQLite records with SQL. The SQLite CLI allows you to issue any valid SQL statements you like. To create SQLite database records, simply issue the appropriate SQL insert commands. Similarly, ..