$sth->prepare(
        table{users}->select(
          all,
          where(
            like{name}->quote('%john%')
          )
        )
      )
##</code><code>##

$sth->prepare( << 'EOS' );
  select * from users where name like '%john%'
EOS