{"id":1665,"date":"2014-12-17T16:09:31","date_gmt":"2014-12-17T16:09:30","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=1665"},"modified":"2025-06-13T23:50:03","modified_gmt":"2025-06-14T06:50:03","slug":"join-me-ushering-developer-preview-3-n1ql","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/","title":{"rendered":"JOIN me in ushering in Developer Preview 3 of N1QL !"},"content":{"rendered":"

Let’s JOIN hands to welcome DP3!
\nI am super excited to announce the immediate availability of Developer Preview 3 of the Query Language from Couchbase (N1QL).<\/p>\n

Its an amazing experience to be a part of this wonderful team that is building a query language that paves the way for creating rich data applications. DP3 is our latest preview release and is a significant milestone for this project. One of the key features of this release is – yes, you guessed it from the title – JOINs.<\/p>\n

An important requirement for any query language is the ability to pull together related data. JOIN allows objects to be combined by their KEYS (an example can be Customers and their Purchases). By default, an INNER join is performed, though it is possible to specify an OUTER join.<\/p>\n

We also have the NEST clause. Instead of producing a cross product join, NESTing produces a single result for each left hand input, while the right hand inputs are collected into an array and ‘nested’ as a single array-valued field in the result object. There is also a reverse operator – the UNNEST clause.<\/p>\n

There are also some really cool ARRAY functions that have been added. I think these truly make the life of a developer, who works with document model, much easier.<\/p>\n

Array slicing is a powerful capability that is made available in DP3 as well. To learn about all these features that I mentioned here, as well as other features, please look at our Documentation<\/a> page. Also, Don Pinto has an excellent blog<\/a> that showcases a sample application using N1QL.<\/p>\n

Please bookmark:\u00a0 https:\/\/query.couchbase.com<\/a>
\nThat will be your one-stop shop for all the latest information on the query language from Couchbase. You will also find our updated and easy to use Online Tutorial there.<\/p>\n

Last, but not the least, ensure you register now for our upcoming N1QL webinar<\/u><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Let’s JOIN hands to welcome DP3! I am super excited to announce the immediate availability of Developer Preview 3 of the Query Language from Couchbase (N1QL). Its an amazing experience to be a part of this wonderful team that is […]<\/p>\n","protected":false},"author":39,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1812],"tags":[],"ppma_author":[9020],"class_list":["post-1665","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-n1ql-query"],"yoast_head":"\nJOIN me in ushering in Developer Preview 3 of N1QL ! - The Couchbase 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:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"JOIN me in ushering in Developer Preview 3 of N1QL !\" \/>\n<meta property=\"og:description\" content=\"Let’s JOIN hands to welcome DP3! I am super excited to announce the immediate availability of Developer Preview 3 of the Query Language from Couchbase (N1QL). Its an amazing experience to be a part of this wonderful team that is […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-12-17T16:09:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T06:50:03+00:00\" \/>\n<meta name=\"author\" content=\"Ilam Siva, SR. Product Manager, Couchbase\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ilam Siva, SR. Product Manager, Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/join-me-ushering-developer-preview-3-n1ql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/join-me-ushering-developer-preview-3-n1ql\\\/\"},\"author\":{\"name\":\"Ilam Siva, SR. Product Manager, Couchbase\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/person\\\/b28482a2be0617cc239914487f3873af\"},\"headline\":\"JOIN me in ushering in Developer Preview 3 of N1QL !\",\"datePublished\":\"2014-12-17T16:09:30+00:00\",\"dateModified\":\"2025-06-14T06:50:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/join-me-ushering-developer-preview-3-n1ql\\\/\"},\"wordCount\":329,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/join-me-ushering-developer-preview-3-n1ql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/1\\\/2022\\\/11\\\/couchbase-nosql-dbaas.png\",\"articleSection\":[\"SQL++ \\\/ N1QL Query\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/join-me-ushering-developer-preview-3-n1ql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/join-me-ushering-developer-preview-3-n1ql\\\/\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/join-me-ushering-developer-preview-3-n1ql\\\/\",\"name\":\"JOIN me in ushering in Developer Preview 3 of N1QL ! - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/join-me-ushering-developer-preview-3-n1ql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/join-me-ushering-developer-preview-3-n1ql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/1\\\/2022\\\/11\\\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2014-12-17T16:09:30+00:00\",\"dateModified\":\"2025-06-14T06:50:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/join-me-ushering-developer-preview-3-n1ql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/join-me-ushering-developer-preview-3-n1ql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/join-me-ushering-developer-preview-3-n1ql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/1\\\/2022\\\/11\\\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/1\\\/2022\\\/11\\\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/join-me-ushering-developer-preview-3-n1ql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"JOIN me in ushering in Developer Preview 3 of N1QL !\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/admin-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/person\\\/b28482a2be0617cc239914487f3873af\",\"name\":\"Ilam Siva, SR. Product Manager, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1616892157452a8a9259927dfbef19ba8b3062e91308f39e46efce3f03738746?s=96&d=mm&r=g7e4a688afe7b38f57aa80ec35aaabe6b\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1616892157452a8a9259927dfbef19ba8b3062e91308f39e46efce3f03738746?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1616892157452a8a9259927dfbef19ba8b3062e91308f39e46efce3f03738746?s=96&d=mm&r=g\",\"caption\":\"Ilam Siva, SR. Product Manager, Couchbase\"},\"description\":\"A former Senior Product Manager at Couchbase, Ilam Siva is responsible for various areas of Couchbase Server product development, roadmap, positioning, messaging and collateral. Ilam is passionate about Big Data and NoSQL and believes that it will push the frontiers of scale, performance and capabilities of next generation applications. Prior to Couchbase, he has worked on Hadoop, Cloud platform and database technologies at Yahoo!, Microsoft and Oracle.\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/author\\\/ilam-siva\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"JOIN me in ushering in Developer Preview 3 of N1QL ! - The Couchbase 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:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/","og_locale":"en_US","og_type":"article","og_title":"JOIN me in ushering in Developer Preview 3 of N1QL !","og_description":"Let’s JOIN hands to welcome DP3! I am super excited to announce the immediate availability of Developer Preview 3 of the Query Language from Couchbase (N1QL). Its an amazing experience to be a part of this wonderful team that is […]","og_url":"https:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/","og_site_name":"The Couchbase Blog","article_published_time":"2014-12-17T16:09:30+00:00","article_modified_time":"2025-06-14T06:50:03+00:00","author":"Ilam Siva, SR. Product Manager, Couchbase","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ilam Siva, SR. Product Manager, Couchbase","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/"},"author":{"name":"Ilam Siva, SR. Product Manager, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/b28482a2be0617cc239914487f3873af"},"headline":"JOIN me in ushering in Developer Preview 3 of N1QL !","datePublished":"2014-12-17T16:09:30+00:00","dateModified":"2025-06-14T06:50:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/"},"wordCount":329,"commentCount":1,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","articleSection":["SQL++ \/ N1QL Query"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/","url":"https:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/","name":"JOIN me in ushering in Developer Preview 3 of N1QL ! - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2014-12-17T16:09:30+00:00","dateModified":"2025-06-14T06:50:03+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/join-me-ushering-developer-preview-3-n1ql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"JOIN me in ushering in Developer Preview 3 of N1QL !"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"The Couchbase Blog","description":"Couchbase, the NoSQL Database","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"The Couchbase Blog","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/b28482a2be0617cc239914487f3873af","name":"Ilam Siva, SR. Product Manager, Couchbase","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1616892157452a8a9259927dfbef19ba8b3062e91308f39e46efce3f03738746?s=96&d=mm&r=g7e4a688afe7b38f57aa80ec35aaabe6b","url":"https:\/\/secure.gravatar.com\/avatar\/1616892157452a8a9259927dfbef19ba8b3062e91308f39e46efce3f03738746?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1616892157452a8a9259927dfbef19ba8b3062e91308f39e46efce3f03738746?s=96&d=mm&r=g","caption":"Ilam Siva, SR. Product Manager, Couchbase"},"description":"A former Senior Product Manager at Couchbase, Ilam Siva is responsible for various areas of Couchbase Server product development, roadmap, positioning, messaging and collateral. Ilam is passionate about Big Data and NoSQL and believes that it will push the frontiers of scale, performance and capabilities of next generation applications. Prior to Couchbase, he has worked on Hadoop, Cloud platform and database technologies at Yahoo!, Microsoft and Oracle.","url":"https:\/\/www.couchbase.com\/blog\/author\/ilam-siva\/"}]}},"acf":[],"authors":[{"term_id":9020,"user_id":39,"is_guest":0,"slug":"ilam-siva","display_name":"Ilam Siva, SR. Product Manager, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/1616892157452a8a9259927dfbef19ba8b3062e91308f39e46efce3f03738746?s=96&d=mm&r=g","0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":""}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts\/1665","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/comments?post=1665"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts\/1665\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/media?parent=1665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/categories?post=1665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/tags?post=1665"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=1665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}