The debug databases are copy, you can modify them from Lua using SQL request (you could in civ5 at least), but as they were just copy for debugging purpose, the DB in memory used by the game was not modified.
You could update text in game with civ5 by modifying the text database first then call the UI event to change the langage... yes, hacky, and it wasn't working on every context IIRC.