backwards compatibility with SQL format