DBeaver how to get back results window
Is it possible you have inadvetantly collapsed the results panel?
If so, you may see a small grey triangle / 'up-arrow' just above the status bar at the bottom of the query window. Hovering your mouse pointer over the triangle / up-arrow icon shows the tool-tip 'Restore':
If you don't see that, perhaps try to post a screenshot of what you are seeing?