In Lianja App Builder RC5.3 i've introduced "local" as a "known" connection to provide the ability to work with data locally then switch to server connections at runtime.

sqlConnect("local") and create VirtualTable myvtable connstr "local" can now be specified to work on local Lianja SQL cursors.

The connection string (or ODBC DSN) can also contain {macro} so that the connection can be switched programmatically without making any code changes.