{"action":"created","issue":{"url":"https://api.github.com/repos/franz-see/Robotframework-Database-Library/issues/85","repository_url":"https://api.github.com/repos/franz-see/Robotframework-Database-Library","labels_url":"https://api.github.com/repos/franz-see/Robotframework-Database-Library/issues/85/labels{/name}","comments_url":"https://api.github.com/repos/franz-see/Robotframework-Database-Library/issues/85/comments","events_url":"https://api.github.com/repos/franz-see/Robotframework-Database-Library/issues/85/events","html_url":"https://github.com/franz-see/Robotframework-Database-Library/issues/85","id":333045410,"node_id":"MDU6SXNzdWUzMzMwNDU0MTA=","number":85,"title":"Add possibility to return query results as a list of dictionaries","user":{"login":"rhapsodyman","id":10989196,"node_id":"MDQ6VXNlcjEwOTg5MTk2","avatar_url":"https://avatars2.githubusercontent.com/u/10989196?v=4","gravatar_id":"","url":"https://api.github.com/users/rhapsodyman","html_url":"https://github.com/rhapsodyman","followers_url":"https://api.github.com/users/rhapsodyman/followers","following_url":"https://api.github.com/users/rhapsodyman/following{/other_user}","gists_url":"https://api.github.com/users/rhapsodyman/gists{/gist_id}","starred_url":"https://api.github.com/users/rhapsodyman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rhapsodyman/subscriptions","organizations_url":"https://api.github.com/users/rhapsodyman/orgs","repos_url":"https://api.github.com/users/rhapsodyman/repos","events_url":"https://api.github.com/users/rhapsodyman/events{/privacy}","received_events_url":"https://api.github.com/users/rhapsodyman/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-06-17T08:21:42Z","updated_at":"2018-06-19T19:06:05Z","closed_at":"2018-06-19T19:06:05Z","author_association":"CONTRIBUTOR","body":"Using indexes like this:\r\n${queryResults} | Query | SELECT first_name, last_name FROM person\r\nLog | ${queryResults[0][1]}, ${queryResults[0][0]}\r\n\r\nis not suitable if you query many columns\r\n\r\nIt will be good to have a possibility to return query results as a list of dictionaries\r\nfor example: for such table\r\n   | AccountID | FirstName | LastName | Address |\r\n   | 1         |  Alex     | Blake    | Some address |\r\n   | 2         |  John     | Blake    | Some other address |\r\n   \r\n   to return \r\n   \r\n   [ {'AccountID' : 1, 'FirstName': Alex, 'LastName': Blake, 'Address': Some Address },\r\n     {'AccountID' : 2, 'FirstName': John, 'LastName': Blake, 'Address': Some other Address }\r\n   ]"},"comment":{"url":"https://api.github.com/repos/franz-see/Robotframework-Database-Library/issues/comments/398510631","html_url":"https://github.com/franz-see/Robotframework-Database-Library/issues/85#issuecomment-398510631","issue_url":"https://api.github.com/repos/franz-see/Robotframework-Database-Library/issues/85","id":398510631,"node_id":"MDEyOklzc3VlQ29tbWVudDM5ODUxMDYzMQ==","user":{"login":"jerry57","id":636374,"node_id":"MDQ6VXNlcjYzNjM3NA==","avatar_url":"https://avatars3.githubusercontent.com/u/636374?v=4","gravatar_id":"","url":"https://api.github.com/users/jerry57","html_url":"https://github.com/jerry57","followers_url":"https://api.github.com/users/jerry57/followers","following_url":"https://api.github.com/users/jerry57/following{/other_user}","gists_url":"https://api.github.com/users/jerry57/gists{/gist_id}","starred_url":"https://api.github.com/users/jerry57/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jerry57/subscriptions","organizations_url":"https://api.github.com/users/jerry57/orgs","repos_url":"https://api.github.com/users/jerry57/repos","events_url":"https://api.github.com/users/jerry57/events{/privacy}","received_events_url":"https://api.github.com/users/jerry57/received_events","type":"User","site_admin":false},"created_at":"2018-06-19T19:06:05Z","updated_at":"2018-06-19T19:06:05Z","author_association":"COLLABORATOR","body":"Code has been merged to master and will be released as part of the next release.  THANKS!"}}
{"actor":{"display_login":"jerry57"}}