# Which version(s) of SQL are supported?

**URL:** <https://community.dremio.com/t/which-version-s-of-sql-are-supported/4635>\
**Category:** Uncategorized\
**Created:** [November 25, 2019, 10:15am UTC](https://community.dremio.com/t/which-version-s-of-sql-are-supported/4635 "2019-11-25T10:15:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![christian.geier](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/christian.geier/32/2115_2.png) [@christian.geier](https://community.dremio.com/u/christian.geier)\
**Post date:** [November 25, 2019, 10:15am UTC](https://community.dremio.com/t/which-version-s-of-sql-are-supported/4635/1 "2019-11-25T10:15:22Z")

</div>

Hi everybody,  
I’m wondering which version(s) of SQL does Dremio support? I suspect this might depend on the data source, but I can’t find anything about it in the docs.

Also, I’m wondering about the completeness of the built-in _Functions_ helper and the online documentation. Are they supposed to be exhaustive? For example, I cannot find _COALESCE_ in the helper (but it’s listed in the documentation).

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [November 25, 2019, 2:34pm UTC](https://community.dremio.com/t/which-version-s-of-sql-are-supported/4635/2 "2019-11-25T14:34:22Z")

</div>

@christian.geier

Are you asking versions of SQL server? or more towards, are we ANSI-Complaint?

You are right, there are some functions that do not come up on the UI like COALESCE or RANK but we do support them. We are working on getting them aligned

[https://docs.dremio.com/sql-reference/sql-functions/conditional.html?h=COALESCE](https://docs.dremio.com/sql-reference/sql-functions/conditional.html?h=COALESCE)

Thanks  
@balaji.ramaswamy

---

<div class="post-metadata">

**Author:** ![christian.geier](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/christian.geier/32/2115_2.png) [@christian.geier](https://community.dremio.com/u/christian.geier)\
**Post date:** [November 25, 2019, 2:49pm UTC](https://community.dremio.com/t/which-version-s-of-sql-are-supported/4635/3 "2019-11-25T14:49:04Z")

</div>

More towards ANSI compliance, for example does dremio support a specific version like SQL:2006 or is it compatible to say Postgresql SQL Version x.y.