Just as you can pass a path argument to the dbapi.connect() function (enabling persistency). This will allow similar functionality as the Session api already provides, but using the dbapi.

Changelog category (leave one):

• Improvement

Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md):

Added path parameter to dbapi

Documentation entry for user-facing changes

• Not sure this requires a documentation entry, but here it is:
  path: the folder path to use for database data on disk.
• Documentation is written (mandatory for new features)

Information about CI checks: https://clickhouse.com/docs/en/development/continuous-integration/