{"id":4631,"date":"2013-03-03T08:30:14","date_gmt":"2013-03-03T16:30:14","guid":{"rendered":"http:\/\/seedcodenext.wordpress.com\/?p=917"},"modified":"2013-03-03T08:30:14","modified_gmt":"2013-03-03T16:30:14","slug":"sqlexplorer-enhanced","status":"publish","type":"post","link":"https:\/\/seedcode.com\/sqlexplorer-enhanced\/","title":{"rendered":"SQLexplorer Enhanced"},"content":{"rendered":"<p>If you\u2019re using SQL in your FM12 work, you&#8217;re in luck. Jason has released a new version of SQLexplorer that writes queries which survive field renaming.<\/p>\n<div class=\"lightbox\"><a href=\"http:\/\/205.186.131.92\/wp-content\/uploads\/2013\/03\/pic.png\"><img decoding=\"async\" class=\"aligncenter size-medium wp-image-918\" alt=\"pic\" src=\"http:\/\/205.186.131.92\/wp-content\/uploads\/2013\/03\/pic.png?\" \/><\/a><\/div>\n<p>It will also apply this abstraction to queries you simply type in there (vs ones you build with the wizard). Big step forward.<\/p>\n<p>Still free and unlocked, the new version is <a href=\"\/filemaker-sql-explorer\/\">here<\/a>.<\/p>\n<p><iframe width=\"560\" height=\"315\" src=\"\/\/www.youtube.com\/embed\/VIBrbxyhLtk?rel=0\" frameborder=\"0\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you\u2019re using SQL in your FM12 work, you&#8217;re in luck. Jason has released a new version of SQLexplorer that writes queries which survive field renaming. It will also apply this abstraction to queries you simply type in there (vs ones you build with the wizard). Big step forward. Still free and unlocked, the new version is here.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[18],"class_list":["post-4631","post","type-post","status-publish","format-standard","hentry","category-whats-next","tag-filemaker-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQLexplorer Enhanced - SeedCode<\/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:\/\/seedcode.com\/sqlexplorer-enhanced\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLexplorer Enhanced - SeedCode\" \/>\n<meta property=\"og:description\" content=\"If you\u2019re using SQL in your FM12 work, you&#8217;re in luck. Jason has released a new version of SQLexplorer that writes queries which survive field renaming. It will also apply this abstraction to queries you simply type in there (vs ones you build with the wizard). Big step forward. Still free and unlocked, the new version is here.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/seedcode.com\/sqlexplorer-enhanced\/\" \/>\n<meta property=\"og:site_name\" content=\"SeedCode\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/seedcoder\" \/>\n<meta property=\"article:published_time\" content=\"2013-03-03T16:30:14+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/205.186.131.92\/wp-content\/uploads\/2013\/03\/pic.png?\" \/>\n<meta name=\"author\" content=\"seedcode\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dayback\" \/>\n<meta name=\"twitter:site\" content=\"@dayback\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"seedcode\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/seedcode.com\/sqlexplorer-enhanced\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/seedcode.com\/sqlexplorer-enhanced\/\"},\"author\":{\"name\":\"seedcode\",\"@id\":\"https:\/\/seedcode.com\/#\/schema\/person\/af42f3f8cbfc8652fb0ffbb3f46f260f\"},\"headline\":\"SQLexplorer Enhanced\",\"datePublished\":\"2013-03-03T16:30:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/seedcode.com\/sqlexplorer-enhanced\/\"},\"wordCount\":62,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/seedcode.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/seedcode.com\/sqlexplorer-enhanced\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/205.186.131.92\/wp-content\/uploads\/2013\/03\/pic.png?\",\"keywords\":[\"FileMaker SQL\"],\"articleSection\":[\"What's Next\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/seedcode.com\/sqlexplorer-enhanced\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/seedcode.com\/sqlexplorer-enhanced\/\",\"url\":\"https:\/\/seedcode.com\/sqlexplorer-enhanced\/\",\"name\":\"SQLexplorer Enhanced - SeedCode\",\"isPartOf\":{\"@id\":\"https:\/\/seedcode.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/seedcode.com\/sqlexplorer-enhanced\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/seedcode.com\/sqlexplorer-enhanced\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/205.186.131.92\/wp-content\/uploads\/2013\/03\/pic.png?\",\"datePublished\":\"2013-03-03T16:30:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/seedcode.com\/sqlexplorer-enhanced\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/seedcode.com\/sqlexplorer-enhanced\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seedcode.com\/sqlexplorer-enhanced\/#primaryimage\",\"url\":\"http:\/\/205.186.131.92\/wp-content\/uploads\/2013\/03\/pic.png?\",\"contentUrl\":\"http:\/\/205.186.131.92\/wp-content\/uploads\/2013\/03\/pic.png?\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/seedcode.com\/sqlexplorer-enhanced\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/seedcode.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQLexplorer Enhanced\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/seedcode.com\/#website\",\"url\":\"https:\/\/seedcode.com\/\",\"name\":\"SeedCode\",\"description\":\"Build the Software You&#039;ve Always Wanted\",\"publisher\":{\"@id\":\"https:\/\/seedcode.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/seedcode.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/seedcode.com\/#organization\",\"name\":\"SeedCode\",\"url\":\"https:\/\/seedcode.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seedcode.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2022\/12\/SeedCodeLogo.png\",\"contentUrl\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2022\/12\/SeedCodeLogo.png\",\"width\":595,\"height\":189,\"caption\":\"SeedCode\"},\"image\":{\"@id\":\"https:\/\/seedcode.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/seedcoder\",\"https:\/\/x.com\/dayback\",\"https:\/\/www.linkedin.com\/company\/seedcode\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/seedcode.com\/#\/schema\/person\/af42f3f8cbfc8652fb0ffbb3f46f260f\",\"name\":\"seedcode\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seedcode.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f0c386c5b845ee7fe111b36b2d87e983811f1f549682de9597a934b9dfd45469?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f0c386c5b845ee7fe111b36b2d87e983811f1f549682de9597a934b9dfd45469?s=96&d=mm&r=g\",\"caption\":\"seedcode\"},\"sameAs\":[\"https:\/\/seedcode.com\"],\"url\":\"https:\/\/seedcode.com\/author\/seedcode\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQLexplorer Enhanced - SeedCode","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:\/\/seedcode.com\/sqlexplorer-enhanced\/","og_locale":"en_US","og_type":"article","og_title":"SQLexplorer Enhanced - SeedCode","og_description":"If you\u2019re using SQL in your FM12 work, you&#8217;re in luck. Jason has released a new version of SQLexplorer that writes queries which survive field renaming. It will also apply this abstraction to queries you simply type in there (vs ones you build with the wizard). Big step forward. Still free and unlocked, the new version is here.","og_url":"https:\/\/seedcode.com\/sqlexplorer-enhanced\/","og_site_name":"SeedCode","article_publisher":"https:\/\/www.facebook.com\/seedcoder","article_published_time":"2013-03-03T16:30:14+00:00","og_image":[{"url":"http:\/\/205.186.131.92\/wp-content\/uploads\/2013\/03\/pic.png?","type":"","width":"","height":""}],"author":"seedcode","twitter_card":"summary_large_image","twitter_creator":"@dayback","twitter_site":"@dayback","twitter_misc":{"Written by":"seedcode"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/seedcode.com\/sqlexplorer-enhanced\/#article","isPartOf":{"@id":"https:\/\/seedcode.com\/sqlexplorer-enhanced\/"},"author":{"name":"seedcode","@id":"https:\/\/seedcode.com\/#\/schema\/person\/af42f3f8cbfc8652fb0ffbb3f46f260f"},"headline":"SQLexplorer Enhanced","datePublished":"2013-03-03T16:30:14+00:00","mainEntityOfPage":{"@id":"https:\/\/seedcode.com\/sqlexplorer-enhanced\/"},"wordCount":62,"commentCount":1,"publisher":{"@id":"https:\/\/seedcode.com\/#organization"},"image":{"@id":"https:\/\/seedcode.com\/sqlexplorer-enhanced\/#primaryimage"},"thumbnailUrl":"http:\/\/205.186.131.92\/wp-content\/uploads\/2013\/03\/pic.png?","keywords":["FileMaker SQL"],"articleSection":["What's Next"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/seedcode.com\/sqlexplorer-enhanced\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/seedcode.com\/sqlexplorer-enhanced\/","url":"https:\/\/seedcode.com\/sqlexplorer-enhanced\/","name":"SQLexplorer Enhanced - SeedCode","isPartOf":{"@id":"https:\/\/seedcode.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/seedcode.com\/sqlexplorer-enhanced\/#primaryimage"},"image":{"@id":"https:\/\/seedcode.com\/sqlexplorer-enhanced\/#primaryimage"},"thumbnailUrl":"http:\/\/205.186.131.92\/wp-content\/uploads\/2013\/03\/pic.png?","datePublished":"2013-03-03T16:30:14+00:00","breadcrumb":{"@id":"https:\/\/seedcode.com\/sqlexplorer-enhanced\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/seedcode.com\/sqlexplorer-enhanced\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seedcode.com\/sqlexplorer-enhanced\/#primaryimage","url":"http:\/\/205.186.131.92\/wp-content\/uploads\/2013\/03\/pic.png?","contentUrl":"http:\/\/205.186.131.92\/wp-content\/uploads\/2013\/03\/pic.png?"},{"@type":"BreadcrumbList","@id":"https:\/\/seedcode.com\/sqlexplorer-enhanced\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/seedcode.com\/"},{"@type":"ListItem","position":2,"name":"SQLexplorer Enhanced"}]},{"@type":"WebSite","@id":"https:\/\/seedcode.com\/#website","url":"https:\/\/seedcode.com\/","name":"SeedCode","description":"Build the Software You&#039;ve Always Wanted","publisher":{"@id":"https:\/\/seedcode.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/seedcode.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/seedcode.com\/#organization","name":"SeedCode","url":"https:\/\/seedcode.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seedcode.com\/#\/schema\/logo\/image\/","url":"https:\/\/seedcode.com\/wp-content\/uploads\/2022\/12\/SeedCodeLogo.png","contentUrl":"https:\/\/seedcode.com\/wp-content\/uploads\/2022\/12\/SeedCodeLogo.png","width":595,"height":189,"caption":"SeedCode"},"image":{"@id":"https:\/\/seedcode.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/seedcoder","https:\/\/x.com\/dayback","https:\/\/www.linkedin.com\/company\/seedcode\/"]},{"@type":"Person","@id":"https:\/\/seedcode.com\/#\/schema\/person\/af42f3f8cbfc8652fb0ffbb3f46f260f","name":"seedcode","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seedcode.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f0c386c5b845ee7fe111b36b2d87e983811f1f549682de9597a934b9dfd45469?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f0c386c5b845ee7fe111b36b2d87e983811f1f549682de9597a934b9dfd45469?s=96&d=mm&r=g","caption":"seedcode"},"sameAs":["https:\/\/seedcode.com"],"url":"https:\/\/seedcode.com\/author\/seedcode\/"}]}},"_links":{"self":[{"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/posts\/4631","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/comments?post=4631"}],"version-history":[{"count":0,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/posts\/4631\/revisions"}],"wp:attachment":[{"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/media?parent=4631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/categories?post=4631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/tags?post=4631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}