SELECT p.id, concat(p.name->>'en_US', ' (Pet)') as name FROM pets p WHERE p.is_tradable = true ORDER BY p.id

All available tables are listed on the left column, more tables will be added soon

For details on how to query jsonb fields see: https://www.postgresql.org/docs/9.5/functions-json.html

Known issues

While data is being downloaded from the server there is no loading indicator yet, just wait a few seconds