robotframework-sqless is a SQL abstraction library for Robot Framework

pip install robotframework-sqless

The example presumes there is a database with a user table and at least a column username.

The database schema and the database configuration must be defined in separate .yml files. For the above example, the following files should apply:

db_config.yml

dbms: sqlite
db: sqless.db

schema.yml

users:
  tablename: user
  fields:
    id: integer
    username: char