Transparent to the application - basically the SQL queries (select, insert, update) in your code base don't have to change at all.

This would be in contrast to e.g. compressing the data in your code before inserting it into the database, then decompressing after you load it.