SELECT a.id, a.name->>'en_US' as name, a.description->>'en_US' as description, a.points, a.is_account_wide, a.display_order, ac.id as category_id, ac.name->>'en_US' as category, aa.value as icon FROM achievements a JOIN achievement_categories ac ON ac.id = a.category_id LEFT JOIN achievement_assets aa ON aa.achievement_media_id = a.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