add a retrieve row method: #302 (comment)

After this is implemented go through the todos in that adr and address them. Also the status should be changed to implemented. After the latter change, we should address future changes in separate ADRs instead of amending that one.