@Zach - I am not 100% sure if VENUS has been specifically used directly with SQLite before, but I believe this can be done using a standard file open command (file type ‘All Files’) in method editor, so long as you properly construct a connection string to establish a connection your specific database, as as well as a command string that structures the query. The final section of this slide deck regarding database integration contains more info, but the other sections may be helpful as well.
Typically people will use VENUS to perform SQL queries using an excel table or a csv as a database, where the command string queries are constructed per typical SQL syntax, but direct database integration is supported as well. In addition to the other deck linked, this deck on Using SQLStatements and Relational Databases in VENUS may also be helpful. The content may be old news for you, but could be helpful for others that follow and see this post in the future. In that spirit, here is an example method highlighting different types of SQL queries from files.
That is correct. Have you reviewed the presentations in the links Nick provided? They go rather in depth on the implementation and examples. Particularly, the slide deck regarding database integration shows the syntax and application, including the use of INSERT, UPDATE, DELETE, SELECT, etc., but essentially the File:Open Command String field will support any SQL statement you could use in a standard query/non-query in something such as MS SQL Server Management Studio. That command string is executed when the “file” (database connection) is opened, so doing a File:Open followed by a File:Close will result in the command being executed and subsequently closing the database connection. With this approach, it does mean that you either want to aggregate multiple INSERTs into a single statement or you would need to Open and Close the “file” over and over again to execute a series of INSERTs, which could result in fairly long run times, especially if you have Method View open in Run Control.