oracle

Sometimes it is needed to store compressed data in the DB. Unfortunately not all the DBs have built-in compression and FUSE compressed FSes are not available for every OS. So it may make sense to store compressed binary blobs in the DB.

Unfortunately when one sees them in DBeaver he sees them compressed, but often they are needed uncompressed. So it'd be nice to have a feature to decompress the

Right now, strings default to equals, we should switch this to contains for a more fluid experience.

Environment

Liquibase Version: 4.4.3

Liquibase Integration & Version: quarkus 2.3.0.Final

Liquibase Extension(s) & Version: liquibase-core only

Database Vendor & Version: MariaDB 10.6.4

Operating System Type & Version: Windows

Description
Add a contract similar to Aave's AddressProvider or Uniswap's getPair() functionality.

Motivation
On-chain lookups of price oracles given the asset addresses.

Justification
String manipulation is difficult and expensive in Solidity, and you usually work with the token address, not its string name.

This is not a bug, everything works fine. It's a small SQL codegen improvement.

linq2db uses nvl to translate ??, which is nice because it's shorter than SQL standard coalesce.

The trick with nvl is that it only accepts 2 parameters, whereas coalesce accepts many.

In our codebase, we have a query that computes an error message based on a list of checks, it looks like this:
![im