How to realize lower() (postresql) in dbix:class

Question

I need the postgresql query: select * from document where lower(app_period) = '2019-08-01 00:00:00+03';

How it will look in dbix::class?

Answer 1

The DBIx::Class::Manual::Cookbook contains an example for that.