{"id":2987,"date":"2025-09-25T09:40:55","date_gmt":"2025-09-25T09:40:55","guid":{"rendered":"https:\/\/learning.workfall.com\/learning\/blog\/helpie_faq\/q-how-do-i-execute-queries-and-handle-results-in-python\/"},"modified":"2025-09-25T09:41:19","modified_gmt":"2025-09-25T09:41:19","slug":"q-how-do-i-execute-queries-and-handle-results-in-python","status":"publish","type":"helpie_faq","link":"https:\/\/learning.workfall.com\/learning\/blog\/helpie_faq\/q-how-do-i-execute-queries-and-handle-results-in-python\/","title":{"rendered":"Q. How do I execute queries and handle results in Python?"},"content":{"rendered":"<p><span style=\"font-weight: 400\">\u00a0<\/span><b>A: <\/b><span style=\"font-weight: 400\">Once connected, use a cursor object to <\/span><span style=\"font-weight: 400\">execute()<\/span><span style=\"font-weight: 400\"> SQL statements (e.g. SELECT, INSERT). Use <\/span><span style=\"font-weight: 400\">fetchone()<\/span><span style=\"font-weight: 400\">, <\/span><span style=\"font-weight: 400\">fetchall()<\/span><span style=\"font-weight: 400\"> or iterate over the cursor to retrieve results. Manage exceptions (e.g. SqlSnowflake errors). Close cursor and connection when done. The blog likely walks through sample code.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0A: Once connected, use a cursor object to execute() SQL statements (e.g. SELECT, INSERT). Use fetchone(), fetchall() or iterate over the cursor to retrieve results. Manage exceptions (e.g. SqlSnowflake errors). Close cursor and connection when done. The blog likely walks through sample code.<\/p>\n","protected":false},"author":257,"featured_media":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"spay_email":""},"helpie_faq_category":[469],"helpie_faq_group":[523],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Q. How do I execute queries and handle results in Python? - The Workfall Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ec2-18-141-20-153.ap-southeast-1.compute.amazonaws.com\/learning\/blog\/helpie_faq\/q-how-do-i-execute-queries-and-handle-results-in-python\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Q. How do I execute queries and handle results in Python? - The Workfall Blog\" \/>\n<meta property=\"og:description\" content=\"\u00a0A: Once connected, use a cursor object to execute() SQL statements (e.g. SELECT, INSERT). Use fetchone(), fetchall() or iterate over the cursor to retrieve results. Manage exceptions (e.g. SqlSnowflake errors). Close cursor and connection when done. The blog likely walks through sample code.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ec2-18-141-20-153.ap-southeast-1.compute.amazonaws.com\/learning\/blog\/helpie_faq\/q-how-do-i-execute-queries-and-handle-results-in-python\/\" \/>\n<meta property=\"og:site_name\" content=\"The Workfall Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/workfall\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-25T09:41:19+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@workfall\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/#organization\",\"name\":\"Workfall - Hire #Kickass Coders On Demand\",\"url\":\"https:\/\/learning.workfall.com\/learning\/blog\/\",\"sameAs\":[\"https:\/\/www.instagram.com\/workfall\/\",\"https:\/\/www.linkedin.com\/company\/workfall\/\",\"https:\/\/facebook.com\/workfall\",\"https:\/\/twitter.com\/workfall\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/i1.wp.com\/18.141.20.153\/learning\/blog\/wp-content\/uploads\/2021\/10\/cropped-WF_logo.png?fit=400%2C400\",\"contentUrl\":\"https:\/\/i1.wp.com\/18.141.20.153\/learning\/blog\/wp-content\/uploads\/2021\/10\/cropped-WF_logo.png?fit=400%2C400\",\"width\":400,\"height\":400,\"caption\":\"Workfall - Hire #Kickass Coders On Demand\"},\"image\":{\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/#website\",\"url\":\"https:\/\/learning.workfall.com\/learning\/blog\/\",\"name\":\"The Workfall Blog\",\"description\":\"#Tech #Remote #Jobs\",\"publisher\":{\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/learning.workfall.com\/learning\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ec2-18-141-20-153.ap-southeast-1.compute.amazonaws.com\/learning\/blog\/helpie_faq\/q-how-do-i-execute-queries-and-handle-results-in-python\/#webpage\",\"url\":\"https:\/\/ec2-18-141-20-153.ap-southeast-1.compute.amazonaws.com\/learning\/blog\/helpie_faq\/q-how-do-i-execute-queries-and-handle-results-in-python\/\",\"name\":\"Q. How do I execute queries and handle results in Python? - The Workfall Blog\",\"isPartOf\":{\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/#website\"},\"datePublished\":\"2025-09-25T09:40:55+00:00\",\"dateModified\":\"2025-09-25T09:41:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/ec2-18-141-20-153.ap-southeast-1.compute.amazonaws.com\/learning\/blog\/helpie_faq\/q-how-do-i-execute-queries-and-handle-results-in-python\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ec2-18-141-20-153.ap-southeast-1.compute.amazonaws.com\/learning\/blog\/helpie_faq\/q-how-do-i-execute-queries-and-handle-results-in-python\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ec2-18-141-20-153.ap-southeast-1.compute.amazonaws.com\/learning\/blog\/helpie_faq\/q-how-do-i-execute-queries-and-handle-results-in-python\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/learning.workfall.com\/learning\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"FAQs\",\"item\":\"https:\/\/ec2-18-141-20-153.ap-southeast-1.compute.amazonaws.com\/learning\/blog\/helpie_faq\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Q. How do I execute queries and handle results in Python?\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Q. How do I execute queries and handle results in Python? - The Workfall Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ec2-18-141-20-153.ap-southeast-1.compute.amazonaws.com\/learning\/blog\/helpie_faq\/q-how-do-i-execute-queries-and-handle-results-in-python\/","og_locale":"en_US","og_type":"article","og_title":"Q. How do I execute queries and handle results in Python? - The Workfall Blog","og_description":"\u00a0A: Once connected, use a cursor object to execute() SQL statements (e.g. SELECT, INSERT). Use fetchone(), fetchall() or iterate over the cursor to retrieve results. Manage exceptions (e.g. SqlSnowflake errors). Close cursor and connection when done. The blog likely walks through sample code.","og_url":"https:\/\/ec2-18-141-20-153.ap-southeast-1.compute.amazonaws.com\/learning\/blog\/helpie_faq\/q-how-do-i-execute-queries-and-handle-results-in-python\/","og_site_name":"The Workfall Blog","article_publisher":"https:\/\/facebook.com\/workfall","article_modified_time":"2025-09-25T09:41:19+00:00","twitter_card":"summary_large_image","twitter_site":"@workfall","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/learning.workfall.com\/learning\/blog\/#organization","name":"Workfall - Hire #Kickass Coders On Demand","url":"https:\/\/learning.workfall.com\/learning\/blog\/","sameAs":["https:\/\/www.instagram.com\/workfall\/","https:\/\/www.linkedin.com\/company\/workfall\/","https:\/\/facebook.com\/workfall","https:\/\/twitter.com\/workfall"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/learning.workfall.com\/learning\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/i1.wp.com\/18.141.20.153\/learning\/blog\/wp-content\/uploads\/2021\/10\/cropped-WF_logo.png?fit=400%2C400","contentUrl":"https:\/\/i1.wp.com\/18.141.20.153\/learning\/blog\/wp-content\/uploads\/2021\/10\/cropped-WF_logo.png?fit=400%2C400","width":400,"height":400,"caption":"Workfall - Hire #Kickass Coders On Demand"},"image":{"@id":"https:\/\/learning.workfall.com\/learning\/blog\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/learning.workfall.com\/learning\/blog\/#website","url":"https:\/\/learning.workfall.com\/learning\/blog\/","name":"The Workfall Blog","description":"#Tech #Remote #Jobs","publisher":{"@id":"https:\/\/learning.workfall.com\/learning\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/learning.workfall.com\/learning\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/ec2-18-141-20-153.ap-southeast-1.compute.amazonaws.com\/learning\/blog\/helpie_faq\/q-how-do-i-execute-queries-and-handle-results-in-python\/#webpage","url":"https:\/\/ec2-18-141-20-153.ap-southeast-1.compute.amazonaws.com\/learning\/blog\/helpie_faq\/q-how-do-i-execute-queries-and-handle-results-in-python\/","name":"Q. How do I execute queries and handle results in Python? - The Workfall Blog","isPartOf":{"@id":"https:\/\/learning.workfall.com\/learning\/blog\/#website"},"datePublished":"2025-09-25T09:40:55+00:00","dateModified":"2025-09-25T09:41:19+00:00","breadcrumb":{"@id":"https:\/\/ec2-18-141-20-153.ap-southeast-1.compute.amazonaws.com\/learning\/blog\/helpie_faq\/q-how-do-i-execute-queries-and-handle-results-in-python\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ec2-18-141-20-153.ap-southeast-1.compute.amazonaws.com\/learning\/blog\/helpie_faq\/q-how-do-i-execute-queries-and-handle-results-in-python\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ec2-18-141-20-153.ap-southeast-1.compute.amazonaws.com\/learning\/blog\/helpie_faq\/q-how-do-i-execute-queries-and-handle-results-in-python\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/learning.workfall.com\/learning\/blog\/"},{"@type":"ListItem","position":2,"name":"FAQs","item":"https:\/\/ec2-18-141-20-153.ap-southeast-1.compute.amazonaws.com\/learning\/blog\/helpie_faq\/"},{"@type":"ListItem","position":3,"name":"Q. How do I execute queries and handle results in Python?"}]}]}},"_links":{"self":[{"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/helpie_faq\/2987"}],"collection":[{"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/helpie_faq"}],"about":[{"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/types\/helpie_faq"}],"author":[{"embeddable":true,"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/users\/257"}],"replies":[{"embeddable":true,"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/comments?post=2987"}],"version-history":[{"count":1,"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/helpie_faq\/2987\/revisions"}],"predecessor-version":[{"id":2992,"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/helpie_faq\/2987\/revisions\/2992"}],"wp:attachment":[{"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/media?parent=2987"}],"wp:term":[{"taxonomy":"helpie_faq_category","embeddable":true,"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/helpie_faq_category?post=2987"},{"taxonomy":"helpie_faq_group","embeddable":true,"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/helpie_faq_group?post=2987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}