diff options
Diffstat (limited to '')
| -rw-r--r-- | docs/sqlglot/executor/python.html | 344 |
1 files changed, 179 insertions, 165 deletions
diff --git a/docs/sqlglot/executor/python.html b/docs/sqlglot/executor/python.html index e565d98..53d61d4 100644 --- a/docs/sqlglot/executor/python.html +++ b/docs/sqlglot/executor/python.html @@ -3,7 +3,7 @@ <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> - <meta name="generator" content="pdoc 14.1.0"/> + <meta name="generator" content="pdoc 14.2.0"/> <title>sqlglot.executor.python API documentation</title> <style>/*! * Bootstrap Reboot v5.0.0 (https://getbootstrap.com/) * Copyright 2011-2021 The Bootstrap Authors * Copyright 2011-2021 Twitter, Inc. * Licensed under MIT (https://github.com/twbs/bootstrap/blob/main/LICENSE) * Forked from Normalize.css, licensed MIT (https://github.com/necolas/normalize.css/blob/master/LICENSE.md) */*,::after,::before{box-sizing:border-box}@media (prefers-reduced-motion:no-preference){:root{scroll-behavior:smooth}}body{margin:0;font-family:system-ui,-apple-system,"Segoe UI",Roboto,"Helvetica Neue",Arial,"Noto Sans","Liberation Sans",sans-serif,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:1rem;font-weight:400;line-height:1.5;color:#212529;background-color:#fff;-webkit-text-size-adjust:100%;-webkit-tap-highlight-color:transparent}hr{margin:1rem 0;color:inherit;background-color:currentColor;border:0;opacity:.25}hr:not([size]){height:1px}h1,h2,h3,h4,h5,h6{margin-top:0;margin-bottom:.5rem;font-weight:500;line-height:1.2}h1{font-size:calc(1.375rem + 1.5vw)}@media (min-width:1200px){h1{font-size:2.5rem}}h2{font-size:calc(1.325rem + .9vw)}@media (min-width:1200px){h2{font-size:2rem}}h3{font-size:calc(1.3rem + .6vw)}@media (min-width:1200px){h3{font-size:1.75rem}}h4{font-size:calc(1.275rem + .3vw)}@media (min-width:1200px){h4{font-size:1.5rem}}h5{font-size:1.25rem}h6{font-size:1rem}p{margin-top:0;margin-bottom:1rem}abbr[data-bs-original-title],abbr[title]{-webkit-text-decoration:underline dotted;text-decoration:underline dotted;cursor:help;-webkit-text-decoration-skip-ink:none;text-decoration-skip-ink:none}address{margin-bottom:1rem;font-style:normal;line-height:inherit}ol,ul{padding-left:2rem}dl,ol,ul{margin-top:0;margin-bottom:1rem}ol ol,ol ul,ul ol,ul ul{margin-bottom:0}dt{font-weight:700}dd{margin-bottom:.5rem;margin-left:0}blockquote{margin:0 0 1rem}b,strong{font-weight:bolder}small{font-size:.875em}mark{padding:.2em;background-color:#fcf8e3}sub,sup{position:relative;font-size:.75em;line-height:0;vertical-align:baseline}sub{bottom:-.25em}sup{top:-.5em}a{color:#0d6efd;text-decoration:underline}a:hover{color:#0a58ca}a:not([href]):not([class]),a:not([href]):not([class]):hover{color:inherit;text-decoration:none}code,kbd,pre,samp{font-family:SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:1em;direction:ltr;unicode-bidi:bidi-override}pre{display:block;margin-top:0;margin-bottom:1rem;overflow:auto;font-size:.875em}pre code{font-size:inherit;color:inherit;word-break:normal}code{font-size:.875em;color:#d63384;word-wrap:break-word}a>code{color:inherit}kbd{padding:.2rem .4rem;font-size:.875em;color:#fff;background-color:#212529;border-radius:.2rem}kbd kbd{padding:0;font-size:1em;font-weight:700}figure{margin:0 0 1rem}img,svg{vertical-align:middle}table{caption-side:bottom;border-collapse:collapse}caption{padding-top:.5rem;padding-bottom:.5rem;color:#6c757d;text-align:left}th{text-align:inherit;text-align:-webkit-match-parent}tbody,td,tfoot,th,thead,tr{border-color:inherit;border-style:solid;border-width:0}label{display:inline-block}button{border-radius:0}button:focus:not(:focus-visible){outline:0}button,input,optgroup,select,textarea{margin:0;font-family:inherit;font-size:inherit;line-height:inherit}button,select{text-transform:none}[role=button]{cursor:pointer}select{word-wrap:normal}select:disabled{opacity:1}[list]::-webkit-calendar-picker-indicator{display:none}[type=button],[type=reset],[type=submit],button{-webkit-appearance:button}[type=button]:not(:disabled),[type=reset]:not(:disabled),[type=submit]:not(:disabled),button:not(:disabled){cursor:pointer}::-moz-focus-inner{padding:0;border-style:none}textarea{resize:vertical}fieldset{min-width:0;padding:0;margin:0;border:0}legend{float:left;width:100%;padding:0;margin-bottom:.5rem;font-size:calc(1.275rem + .3vw);line-height:inherit}@media (min-width:1200px){legend{font-size:1.5rem}}legend+*{clear:left}::-webkit-datetime-edit-day-field,::-webkit-datetime-edit-fields-wrapper,::-webkit-datetime-edit-hour-field,::-webkit-datetime-edit-minute,::-webkit-datetime-edit-month-field,::-webkit-datetime-edit-text,::-webkit-datetime-edit-year-field{padding:0}::-webkit-inner-spin-button{height:auto}[type=search]{outline-offset:-2px;-webkit-appearance:textfield}::-webkit-search-decoration{-webkit-appearance:none}::-webkit-color-swatch-wrapper{padding:0}::file-selector-button{font:inherit}::-webkit-file-upload-button{font:inherit;-webkit-appearance:button}output{display:inline-block}iframe{border:0}summary{display:list-item;cursor:pointer}progress{vertical-align:baseline}[hidden]{display:none!important}</style> @@ -542,108 +542,111 @@ </span><span id="L-343"><a href="#L-343"><span class="linenos">343</span></a> <span class="k">else</span><span class="p">:</span> </span><span id="L-344"><a href="#L-344"><span class="linenos">344</span></a> <span class="n">sink</span><span class="o">.</span><span class="n">rows</span> <span class="o">=</span> <span class="n">left</span><span class="o">.</span><span class="n">rows</span> <span class="o">+</span> <span class="n">right</span><span class="o">.</span><span class="n">rows</span> </span><span id="L-345"><a href="#L-345"><span class="linenos">345</span></a> -</span><span id="L-346"><a href="#L-346"><span class="linenos">346</span></a> <span class="k">return</span> <span class="bp">self</span><span class="o">.</span><span class="n">context</span><span class="p">({</span><span class="n">step</span><span class="o">.</span><span class="n">name</span><span class="p">:</span> <span class="n">sink</span><span class="p">})</span> -</span><span id="L-347"><a href="#L-347"><span class="linenos">347</span></a> +</span><span id="L-346"><a href="#L-346"><span class="linenos">346</span></a> <span class="k">if</span> <span class="ow">not</span> <span class="n">math</span><span class="o">.</span><span class="n">isinf</span><span class="p">(</span><span class="n">step</span><span class="o">.</span><span class="n">limit</span><span class="p">):</span> +</span><span id="L-347"><a href="#L-347"><span class="linenos">347</span></a> <span class="n">sink</span><span class="o">.</span><span class="n">rows</span> <span class="o">=</span> <span class="n">sink</span><span class="o">.</span><span class="n">rows</span><span class="p">[</span><span class="mi">0</span> <span class="p">:</span> <span class="n">step</span><span class="o">.</span><span class="n">limit</span><span class="p">]</span> </span><span id="L-348"><a href="#L-348"><span class="linenos">348</span></a> -</span><span id="L-349"><a href="#L-349"><span class="linenos">349</span></a><span class="k">def</span> <span class="nf">_ordered_py</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">expression</span><span class="p">):</span> -</span><span id="L-350"><a href="#L-350"><span class="linenos">350</span></a> <span class="n">this</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span> <span class="s2">"this"</span><span class="p">)</span> -</span><span id="L-351"><a href="#L-351"><span class="linenos">351</span></a> <span class="n">desc</span> <span class="o">=</span> <span class="s2">"True"</span> <span class="k">if</span> <span class="n">expression</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="s2">"desc"</span><span class="p">)</span> <span class="k">else</span> <span class="s2">"False"</span> -</span><span id="L-352"><a href="#L-352"><span class="linenos">352</span></a> <span class="n">nulls_first</span> <span class="o">=</span> <span class="s2">"True"</span> <span class="k">if</span> <span class="n">expression</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="s2">"nulls_first"</span><span class="p">)</span> <span class="k">else</span> <span class="s2">"False"</span> -</span><span id="L-353"><a href="#L-353"><span class="linenos">353</span></a> <span class="k">return</span> <span class="sa">f</span><span class="s2">"ORDERED(</span><span class="si">{</span><span class="n">this</span><span class="si">}</span><span class="s2">, </span><span class="si">{</span><span class="n">desc</span><span class="si">}</span><span class="s2">, </span><span class="si">{</span><span class="n">nulls_first</span><span class="si">}</span><span class="s2">)"</span> -</span><span id="L-354"><a href="#L-354"><span class="linenos">354</span></a> -</span><span id="L-355"><a href="#L-355"><span class="linenos">355</span></a> -</span><span id="L-356"><a href="#L-356"><span class="linenos">356</span></a><span class="k">def</span> <span class="nf">_rename</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">):</span> -</span><span id="L-357"><a href="#L-357"><span class="linenos">357</span></a> <span class="k">try</span><span class="p">:</span> -</span><span id="L-358"><a href="#L-358"><span class="linenos">358</span></a> <span class="n">values</span> <span class="o">=</span> <span class="nb">list</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">values</span><span class="p">())</span> -</span><span id="L-359"><a href="#L-359"><span class="linenos">359</span></a> -</span><span id="L-360"><a href="#L-360"><span class="linenos">360</span></a> <span class="k">if</span> <span class="nb">len</span><span class="p">(</span><span class="n">values</span><span class="p">)</span> <span class="o">==</span> <span class="mi">1</span><span class="p">:</span> -</span><span id="L-361"><a href="#L-361"><span class="linenos">361</span></a> <span class="n">values</span> <span class="o">=</span> <span class="n">values</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span> -</span><span id="L-362"><a href="#L-362"><span class="linenos">362</span></a> <span class="k">if</span> <span class="ow">not</span> <span class="nb">isinstance</span><span class="p">(</span><span class="n">values</span><span class="p">,</span> <span class="nb">list</span><span class="p">):</span> -</span><span id="L-363"><a href="#L-363"><span class="linenos">363</span></a> <span class="k">return</span> <span class="bp">self</span><span class="o">.</span><span class="n">func</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">key</span><span class="p">,</span> <span class="n">values</span><span class="p">)</span> -</span><span id="L-364"><a href="#L-364"><span class="linenos">364</span></a> <span class="k">return</span> <span class="bp">self</span><span class="o">.</span><span class="n">func</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">key</span><span class="p">,</span> <span class="o">*</span><span class="n">values</span><span class="p">)</span> -</span><span id="L-365"><a href="#L-365"><span class="linenos">365</span></a> -</span><span id="L-366"><a href="#L-366"><span class="linenos">366</span></a> <span class="k">if</span> <span class="nb">isinstance</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="n">exp</span><span class="o">.</span><span class="n">Func</span><span class="p">)</span> <span class="ow">and</span> <span class="n">e</span><span class="o">.</span><span class="n">is_var_len_args</span><span class="p">:</span> -</span><span id="L-367"><a href="#L-367"><span class="linenos">367</span></a> <span class="o">*</span><span class="n">head</span><span class="p">,</span> <span class="n">tail</span> <span class="o">=</span> <span class="n">values</span> -</span><span id="L-368"><a href="#L-368"><span class="linenos">368</span></a> <span class="k">return</span> <span class="bp">self</span><span class="o">.</span><span class="n">func</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">key</span><span class="p">,</span> <span class="o">*</span><span class="n">head</span><span class="p">,</span> <span class="o">*</span><span class="n">tail</span><span class="p">)</span> -</span><span id="L-369"><a href="#L-369"><span class="linenos">369</span></a> -</span><span id="L-370"><a href="#L-370"><span class="linenos">370</span></a> <span class="k">return</span> <span class="bp">self</span><span class="o">.</span><span class="n">func</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">key</span><span class="p">,</span> <span class="o">*</span><span class="n">values</span><span class="p">)</span> -</span><span id="L-371"><a href="#L-371"><span class="linenos">371</span></a> <span class="k">except</span> <span class="ne">Exception</span> <span class="k">as</span> <span class="n">ex</span><span class="p">:</span> -</span><span id="L-372"><a href="#L-372"><span class="linenos">372</span></a> <span class="k">raise</span> <span class="ne">Exception</span><span class="p">(</span><span class="sa">f</span><span class="s2">"Could not rename </span><span class="si">{</span><span class="nb">repr</span><span class="p">(</span><span class="n">e</span><span class="p">)</span><span class="si">}</span><span class="s2">"</span><span class="p">)</span> <span class="kn">from</span> <span class="nn">ex</span> -</span><span id="L-373"><a href="#L-373"><span class="linenos">373</span></a> -</span><span id="L-374"><a href="#L-374"><span class="linenos">374</span></a> -</span><span id="L-375"><a href="#L-375"><span class="linenos">375</span></a><span class="k">def</span> <span class="nf">_case_sql</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">expression</span><span class="p">):</span> -</span><span id="L-376"><a href="#L-376"><span class="linenos">376</span></a> <span class="n">this</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span> <span class="s2">"this"</span><span class="p">)</span> -</span><span id="L-377"><a href="#L-377"><span class="linenos">377</span></a> <span class="n">chain</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span> <span class="s2">"default"</span><span class="p">)</span> <span class="ow">or</span> <span class="s2">"None"</span> -</span><span id="L-378"><a href="#L-378"><span class="linenos">378</span></a> -</span><span id="L-379"><a href="#L-379"><span class="linenos">379</span></a> <span class="k">for</span> <span class="n">e</span> <span class="ow">in</span> <span class="nb">reversed</span><span class="p">(</span><span class="n">expression</span><span class="o">.</span><span class="n">args</span><span class="p">[</span><span class="s2">"ifs"</span><span class="p">]):</span> -</span><span id="L-380"><a href="#L-380"><span class="linenos">380</span></a> <span class="n">true</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"true"</span><span class="p">)</span> -</span><span id="L-381"><a href="#L-381"><span class="linenos">381</span></a> <span class="n">condition</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"this"</span><span class="p">)</span> -</span><span id="L-382"><a href="#L-382"><span class="linenos">382</span></a> <span class="n">condition</span> <span class="o">=</span> <span class="sa">f</span><span class="s2">"</span><span class="si">{</span><span class="n">this</span><span class="si">}</span><span class="s2"> = (</span><span class="si">{</span><span class="n">condition</span><span class="si">}</span><span class="s2">)"</span> <span class="k">if</span> <span class="n">this</span> <span class="k">else</span> <span class="n">condition</span> -</span><span id="L-383"><a href="#L-383"><span class="linenos">383</span></a> <span class="n">chain</span> <span class="o">=</span> <span class="sa">f</span><span class="s2">"</span><span class="si">{</span><span class="n">true</span><span class="si">}</span><span class="s2"> if </span><span class="si">{</span><span class="n">condition</span><span class="si">}</span><span class="s2"> else (</span><span class="si">{</span><span class="n">chain</span><span class="si">}</span><span class="s2">)"</span> -</span><span id="L-384"><a href="#L-384"><span class="linenos">384</span></a> -</span><span id="L-385"><a href="#L-385"><span class="linenos">385</span></a> <span class="k">return</span> <span class="n">chain</span> -</span><span id="L-386"><a href="#L-386"><span class="linenos">386</span></a> +</span><span id="L-349"><a href="#L-349"><span class="linenos">349</span></a> <span class="k">return</span> <span class="bp">self</span><span class="o">.</span><span class="n">context</span><span class="p">({</span><span class="n">step</span><span class="o">.</span><span class="n">name</span><span class="p">:</span> <span class="n">sink</span><span class="p">})</span> +</span><span id="L-350"><a href="#L-350"><span class="linenos">350</span></a> +</span><span id="L-351"><a href="#L-351"><span class="linenos">351</span></a> +</span><span id="L-352"><a href="#L-352"><span class="linenos">352</span></a><span class="k">def</span> <span class="nf">_ordered_py</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">expression</span><span class="p">):</span> +</span><span id="L-353"><a href="#L-353"><span class="linenos">353</span></a> <span class="n">this</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span> <span class="s2">"this"</span><span class="p">)</span> +</span><span id="L-354"><a href="#L-354"><span class="linenos">354</span></a> <span class="n">desc</span> <span class="o">=</span> <span class="s2">"True"</span> <span class="k">if</span> <span class="n">expression</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="s2">"desc"</span><span class="p">)</span> <span class="k">else</span> <span class="s2">"False"</span> +</span><span id="L-355"><a href="#L-355"><span class="linenos">355</span></a> <span class="n">nulls_first</span> <span class="o">=</span> <span class="s2">"True"</span> <span class="k">if</span> <span class="n">expression</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="s2">"nulls_first"</span><span class="p">)</span> <span class="k">else</span> <span class="s2">"False"</span> +</span><span id="L-356"><a href="#L-356"><span class="linenos">356</span></a> <span class="k">return</span> <span class="sa">f</span><span class="s2">"ORDERED(</span><span class="si">{</span><span class="n">this</span><span class="si">}</span><span class="s2">, </span><span class="si">{</span><span class="n">desc</span><span class="si">}</span><span class="s2">, </span><span class="si">{</span><span class="n">nulls_first</span><span class="si">}</span><span class="s2">)"</span> +</span><span id="L-357"><a href="#L-357"><span class="linenos">357</span></a> +</span><span id="L-358"><a href="#L-358"><span class="linenos">358</span></a> +</span><span id="L-359"><a href="#L-359"><span class="linenos">359</span></a><span class="k">def</span> <span class="nf">_rename</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">):</span> +</span><span id="L-360"><a href="#L-360"><span class="linenos">360</span></a> <span class="k">try</span><span class="p">:</span> +</span><span id="L-361"><a href="#L-361"><span class="linenos">361</span></a> <span class="n">values</span> <span class="o">=</span> <span class="nb">list</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">values</span><span class="p">())</span> +</span><span id="L-362"><a href="#L-362"><span class="linenos">362</span></a> +</span><span id="L-363"><a href="#L-363"><span class="linenos">363</span></a> <span class="k">if</span> <span class="nb">len</span><span class="p">(</span><span class="n">values</span><span class="p">)</span> <span class="o">==</span> <span class="mi">1</span><span class="p">:</span> +</span><span id="L-364"><a href="#L-364"><span class="linenos">364</span></a> <span class="n">values</span> <span class="o">=</span> <span class="n">values</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span> +</span><span id="L-365"><a href="#L-365"><span class="linenos">365</span></a> <span class="k">if</span> <span class="ow">not</span> <span class="nb">isinstance</span><span class="p">(</span><span class="n">values</span><span class="p">,</span> <span class="nb">list</span><span class="p">):</span> +</span><span id="L-366"><a href="#L-366"><span class="linenos">366</span></a> <span class="k">return</span> <span class="bp">self</span><span class="o">.</span><span class="n">func</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">key</span><span class="p">,</span> <span class="n">values</span><span class="p">)</span> +</span><span id="L-367"><a href="#L-367"><span class="linenos">367</span></a> <span class="k">return</span> <span class="bp">self</span><span class="o">.</span><span class="n">func</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">key</span><span class="p">,</span> <span class="o">*</span><span class="n">values</span><span class="p">)</span> +</span><span id="L-368"><a href="#L-368"><span class="linenos">368</span></a> +</span><span id="L-369"><a href="#L-369"><span class="linenos">369</span></a> <span class="k">if</span> <span class="nb">isinstance</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="n">exp</span><span class="o">.</span><span class="n">Func</span><span class="p">)</span> <span class="ow">and</span> <span class="n">e</span><span class="o">.</span><span class="n">is_var_len_args</span><span class="p">:</span> +</span><span id="L-370"><a href="#L-370"><span class="linenos">370</span></a> <span class="o">*</span><span class="n">head</span><span class="p">,</span> <span class="n">tail</span> <span class="o">=</span> <span class="n">values</span> +</span><span id="L-371"><a href="#L-371"><span class="linenos">371</span></a> <span class="k">return</span> <span class="bp">self</span><span class="o">.</span><span class="n">func</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">key</span><span class="p">,</span> <span class="o">*</span><span class="n">head</span><span class="p">,</span> <span class="o">*</span><span class="n">tail</span><span class="p">)</span> +</span><span id="L-372"><a href="#L-372"><span class="linenos">372</span></a> +</span><span id="L-373"><a href="#L-373"><span class="linenos">373</span></a> <span class="k">return</span> <span class="bp">self</span><span class="o">.</span><span class="n">func</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">key</span><span class="p">,</span> <span class="o">*</span><span class="n">values</span><span class="p">)</span> +</span><span id="L-374"><a href="#L-374"><span class="linenos">374</span></a> <span class="k">except</span> <span class="ne">Exception</span> <span class="k">as</span> <span class="n">ex</span><span class="p">:</span> +</span><span id="L-375"><a href="#L-375"><span class="linenos">375</span></a> <span class="k">raise</span> <span class="ne">Exception</span><span class="p">(</span><span class="sa">f</span><span class="s2">"Could not rename </span><span class="si">{</span><span class="nb">repr</span><span class="p">(</span><span class="n">e</span><span class="p">)</span><span class="si">}</span><span class="s2">"</span><span class="p">)</span> <span class="kn">from</span> <span class="nn">ex</span> +</span><span id="L-376"><a href="#L-376"><span class="linenos">376</span></a> +</span><span id="L-377"><a href="#L-377"><span class="linenos">377</span></a> +</span><span id="L-378"><a href="#L-378"><span class="linenos">378</span></a><span class="k">def</span> <span class="nf">_case_sql</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">expression</span><span class="p">):</span> +</span><span id="L-379"><a href="#L-379"><span class="linenos">379</span></a> <span class="n">this</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span> <span class="s2">"this"</span><span class="p">)</span> +</span><span id="L-380"><a href="#L-380"><span class="linenos">380</span></a> <span class="n">chain</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span> <span class="s2">"default"</span><span class="p">)</span> <span class="ow">or</span> <span class="s2">"None"</span> +</span><span id="L-381"><a href="#L-381"><span class="linenos">381</span></a> +</span><span id="L-382"><a href="#L-382"><span class="linenos">382</span></a> <span class="k">for</span> <span class="n">e</span> <span class="ow">in</span> <span class="nb">reversed</span><span class="p">(</span><span class="n">expression</span><span class="o">.</span><span class="n">args</span><span class="p">[</span><span class="s2">"ifs"</span><span class="p">]):</span> +</span><span id="L-383"><a href="#L-383"><span class="linenos">383</span></a> <span class="n">true</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"true"</span><span class="p">)</span> +</span><span id="L-384"><a href="#L-384"><span class="linenos">384</span></a> <span class="n">condition</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"this"</span><span class="p">)</span> +</span><span id="L-385"><a href="#L-385"><span class="linenos">385</span></a> <span class="n">condition</span> <span class="o">=</span> <span class="sa">f</span><span class="s2">"</span><span class="si">{</span><span class="n">this</span><span class="si">}</span><span class="s2"> = (</span><span class="si">{</span><span class="n">condition</span><span class="si">}</span><span class="s2">)"</span> <span class="k">if</span> <span class="n">this</span> <span class="k">else</span> <span class="n">condition</span> +</span><span id="L-386"><a href="#L-386"><span class="linenos">386</span></a> <span class="n">chain</span> <span class="o">=</span> <span class="sa">f</span><span class="s2">"</span><span class="si">{</span><span class="n">true</span><span class="si">}</span><span class="s2"> if </span><span class="si">{</span><span class="n">condition</span><span class="si">}</span><span class="s2"> else (</span><span class="si">{</span><span class="n">chain</span><span class="si">}</span><span class="s2">)"</span> </span><span id="L-387"><a href="#L-387"><span class="linenos">387</span></a> -</span><span id="L-388"><a href="#L-388"><span class="linenos">388</span></a><span class="k">def</span> <span class="nf">_lambda_sql</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="n">exp</span><span class="o">.</span><span class="n">Lambda</span><span class="p">)</span> <span class="o">-></span> <span class="nb">str</span><span class="p">:</span> -</span><span id="L-389"><a href="#L-389"><span class="linenos">389</span></a> <span class="n">names</span> <span class="o">=</span> <span class="p">{</span><span class="n">e</span><span class="o">.</span><span class="n">name</span><span class="o">.</span><span class="n">lower</span><span class="p">()</span> <span class="k">for</span> <span class="n">e</span> <span class="ow">in</span> <span class="n">e</span><span class="o">.</span><span class="n">expressions</span><span class="p">}</span> +</span><span id="L-388"><a href="#L-388"><span class="linenos">388</span></a> <span class="k">return</span> <span class="n">chain</span> +</span><span id="L-389"><a href="#L-389"><span class="linenos">389</span></a> </span><span id="L-390"><a href="#L-390"><span class="linenos">390</span></a> -</span><span id="L-391"><a href="#L-391"><span class="linenos">391</span></a> <span class="n">e</span> <span class="o">=</span> <span class="n">e</span><span class="o">.</span><span class="n">transform</span><span class="p">(</span> -</span><span id="L-392"><a href="#L-392"><span class="linenos">392</span></a> <span class="k">lambda</span> <span class="n">n</span><span class="p">:</span> <span class="n">exp</span><span class="o">.</span><span class="n">var</span><span class="p">(</span><span class="n">n</span><span class="o">.</span><span class="n">name</span><span class="p">)</span> -</span><span id="L-393"><a href="#L-393"><span class="linenos">393</span></a> <span class="k">if</span> <span class="nb">isinstance</span><span class="p">(</span><span class="n">n</span><span class="p">,</span> <span class="n">exp</span><span class="o">.</span><span class="n">Identifier</span><span class="p">)</span> <span class="ow">and</span> <span class="n">n</span><span class="o">.</span><span class="n">name</span><span class="o">.</span><span class="n">lower</span><span class="p">()</span> <span class="ow">in</span> <span class="n">names</span> -</span><span id="L-394"><a href="#L-394"><span class="linenos">394</span></a> <span class="k">else</span> <span class="n">n</span> -</span><span id="L-395"><a href="#L-395"><span class="linenos">395</span></a> <span class="p">)</span> -</span><span id="L-396"><a href="#L-396"><span class="linenos">396</span></a> -</span><span id="L-397"><a href="#L-397"><span class="linenos">397</span></a> <span class="k">return</span> <span class="sa">f</span><span class="s2">"lambda </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">expressions</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="n">flat</span><span class="o">=</span><span class="kc">True</span><span class="p">)</span><span class="si">}</span><span class="s2">: </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'this'</span><span class="p">)</span><span class="si">}</span><span class="s2">"</span> -</span><span id="L-398"><a href="#L-398"><span class="linenos">398</span></a> +</span><span id="L-391"><a href="#L-391"><span class="linenos">391</span></a><span class="k">def</span> <span class="nf">_lambda_sql</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="n">exp</span><span class="o">.</span><span class="n">Lambda</span><span class="p">)</span> <span class="o">-></span> <span class="nb">str</span><span class="p">:</span> +</span><span id="L-392"><a href="#L-392"><span class="linenos">392</span></a> <span class="n">names</span> <span class="o">=</span> <span class="p">{</span><span class="n">e</span><span class="o">.</span><span class="n">name</span><span class="o">.</span><span class="n">lower</span><span class="p">()</span> <span class="k">for</span> <span class="n">e</span> <span class="ow">in</span> <span class="n">e</span><span class="o">.</span><span class="n">expressions</span><span class="p">}</span> +</span><span id="L-393"><a href="#L-393"><span class="linenos">393</span></a> +</span><span id="L-394"><a href="#L-394"><span class="linenos">394</span></a> <span class="n">e</span> <span class="o">=</span> <span class="n">e</span><span class="o">.</span><span class="n">transform</span><span class="p">(</span> +</span><span id="L-395"><a href="#L-395"><span class="linenos">395</span></a> <span class="k">lambda</span> <span class="n">n</span><span class="p">:</span> <span class="n">exp</span><span class="o">.</span><span class="n">var</span><span class="p">(</span><span class="n">n</span><span class="o">.</span><span class="n">name</span><span class="p">)</span> +</span><span id="L-396"><a href="#L-396"><span class="linenos">396</span></a> <span class="k">if</span> <span class="nb">isinstance</span><span class="p">(</span><span class="n">n</span><span class="p">,</span> <span class="n">exp</span><span class="o">.</span><span class="n">Identifier</span><span class="p">)</span> <span class="ow">and</span> <span class="n">n</span><span class="o">.</span><span class="n">name</span><span class="o">.</span><span class="n">lower</span><span class="p">()</span> <span class="ow">in</span> <span class="n">names</span> +</span><span id="L-397"><a href="#L-397"><span class="linenos">397</span></a> <span class="k">else</span> <span class="n">n</span> +</span><span id="L-398"><a href="#L-398"><span class="linenos">398</span></a> <span class="p">)</span> </span><span id="L-399"><a href="#L-399"><span class="linenos">399</span></a> -</span><span id="L-400"><a href="#L-400"><span class="linenos">400</span></a><span class="k">def</span> <span class="nf">_div_sql</span><span class="p">(</span><span class="bp">self</span><span class="p">:</span> <span class="n">generator</span><span class="o">.</span><span class="n">Generator</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="n">exp</span><span class="o">.</span><span class="n">Div</span><span class="p">)</span> <span class="o">-></span> <span class="nb">str</span><span class="p">:</span> -</span><span id="L-401"><a href="#L-401"><span class="linenos">401</span></a> <span class="n">denominator</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"expression"</span><span class="p">)</span> +</span><span id="L-400"><a href="#L-400"><span class="linenos">400</span></a> <span class="k">return</span> <span class="sa">f</span><span class="s2">"lambda </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">expressions</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="n">flat</span><span class="o">=</span><span class="kc">True</span><span class="p">)</span><span class="si">}</span><span class="s2">: </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'this'</span><span class="p">)</span><span class="si">}</span><span class="s2">"</span> +</span><span id="L-401"><a href="#L-401"><span class="linenos">401</span></a> </span><span id="L-402"><a href="#L-402"><span class="linenos">402</span></a> -</span><span id="L-403"><a href="#L-403"><span class="linenos">403</span></a> <span class="k">if</span> <span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="s2">"safe"</span><span class="p">):</span> -</span><span id="L-404"><a href="#L-404"><span class="linenos">404</span></a> <span class="n">denominator</span> <span class="o">+=</span> <span class="s2">" or None"</span> +</span><span id="L-403"><a href="#L-403"><span class="linenos">403</span></a><span class="k">def</span> <span class="nf">_div_sql</span><span class="p">(</span><span class="bp">self</span><span class="p">:</span> <span class="n">generator</span><span class="o">.</span><span class="n">Generator</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="n">exp</span><span class="o">.</span><span class="n">Div</span><span class="p">)</span> <span class="o">-></span> <span class="nb">str</span><span class="p">:</span> +</span><span id="L-404"><a href="#L-404"><span class="linenos">404</span></a> <span class="n">denominator</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"expression"</span><span class="p">)</span> </span><span id="L-405"><a href="#L-405"><span class="linenos">405</span></a> -</span><span id="L-406"><a href="#L-406"><span class="linenos">406</span></a> <span class="n">sql</span> <span class="o">=</span> <span class="sa">f</span><span class="s2">"DIV(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'this'</span><span class="p">)</span><span class="si">}</span><span class="s2">, </span><span class="si">{</span><span class="n">denominator</span><span class="si">}</span><span class="s2">)"</span> -</span><span id="L-407"><a href="#L-407"><span class="linenos">407</span></a> -</span><span id="L-408"><a href="#L-408"><span class="linenos">408</span></a> <span class="k">if</span> <span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="s2">"typed"</span><span class="p">):</span> -</span><span id="L-409"><a href="#L-409"><span class="linenos">409</span></a> <span class="n">sql</span> <span class="o">=</span> <span class="sa">f</span><span class="s2">"int(</span><span class="si">{</span><span class="n">sql</span><span class="si">}</span><span class="s2">)"</span> +</span><span id="L-406"><a href="#L-406"><span class="linenos">406</span></a> <span class="k">if</span> <span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="s2">"safe"</span><span class="p">):</span> +</span><span id="L-407"><a href="#L-407"><span class="linenos">407</span></a> <span class="n">denominator</span> <span class="o">+=</span> <span class="s2">" or None"</span> +</span><span id="L-408"><a href="#L-408"><span class="linenos">408</span></a> +</span><span id="L-409"><a href="#L-409"><span class="linenos">409</span></a> <span class="n">sql</span> <span class="o">=</span> <span class="sa">f</span><span class="s2">"DIV(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'this'</span><span class="p">)</span><span class="si">}</span><span class="s2">, </span><span class="si">{</span><span class="n">denominator</span><span class="si">}</span><span class="s2">)"</span> </span><span id="L-410"><a href="#L-410"><span class="linenos">410</span></a> -</span><span id="L-411"><a href="#L-411"><span class="linenos">411</span></a> <span class="k">return</span> <span class="n">sql</span> -</span><span id="L-412"><a href="#L-412"><span class="linenos">412</span></a> +</span><span id="L-411"><a href="#L-411"><span class="linenos">411</span></a> <span class="k">if</span> <span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="s2">"typed"</span><span class="p">):</span> +</span><span id="L-412"><a href="#L-412"><span class="linenos">412</span></a> <span class="n">sql</span> <span class="o">=</span> <span class="sa">f</span><span class="s2">"int(</span><span class="si">{</span><span class="n">sql</span><span class="si">}</span><span class="s2">)"</span> </span><span id="L-413"><a href="#L-413"><span class="linenos">413</span></a> -</span><span id="L-414"><a href="#L-414"><span class="linenos">414</span></a><span class="k">class</span> <span class="nc">Python</span><span class="p">(</span><span class="n">Dialect</span><span class="p">):</span> -</span><span id="L-415"><a href="#L-415"><span class="linenos">415</span></a> <span class="k">class</span> <span class="nc">Tokenizer</span><span class="p">(</span><span class="n">tokens</span><span class="o">.</span><span class="n">Tokenizer</span><span class="p">):</span> -</span><span id="L-416"><a href="#L-416"><span class="linenos">416</span></a> <span class="n">STRING_ESCAPES</span> <span class="o">=</span> <span class="p">[</span><span class="s2">"</span><span class="se">\\</span><span class="s2">"</span><span class="p">]</span> -</span><span id="L-417"><a href="#L-417"><span class="linenos">417</span></a> -</span><span id="L-418"><a href="#L-418"><span class="linenos">418</span></a> <span class="k">class</span> <span class="nc">Generator</span><span class="p">(</span><span class="n">generator</span><span class="o">.</span><span class="n">Generator</span><span class="p">):</span> -</span><span id="L-419"><a href="#L-419"><span class="linenos">419</span></a> <span class="n">TRANSFORMS</span> <span class="o">=</span> <span class="p">{</span> -</span><span id="L-420"><a href="#L-420"><span class="linenos">420</span></a> <span class="o">**</span><span class="p">{</span><span class="n">klass</span><span class="p">:</span> <span class="n">_rename</span> <span class="k">for</span> <span class="n">klass</span> <span class="ow">in</span> <span class="n">subclasses</span><span class="p">(</span><span class="n">exp</span><span class="o">.</span><span class="vm">__name__</span><span class="p">,</span> <span class="n">exp</span><span class="o">.</span><span class="n">Binary</span><span class="p">)},</span> -</span><span id="L-421"><a href="#L-421"><span class="linenos">421</span></a> <span class="o">**</span><span class="p">{</span><span class="n">klass</span><span class="p">:</span> <span class="n">_rename</span> <span class="k">for</span> <span class="n">klass</span> <span class="ow">in</span> <span class="n">exp</span><span class="o">.</span><span class="n">ALL_FUNCTIONS</span><span class="p">},</span> -</span><span id="L-422"><a href="#L-422"><span class="linenos">422</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Case</span><span class="p">:</span> <span class="n">_case_sql</span><span class="p">,</span> -</span><span id="L-423"><a href="#L-423"><span class="linenos">423</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Alias</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">),</span> -</span><span id="L-424"><a href="#L-424"><span class="linenos">424</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Array</span><span class="p">:</span> <span class="n">inline_array_sql</span><span class="p">,</span> -</span><span id="L-425"><a href="#L-425"><span class="linenos">425</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">And</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"and"</span><span class="p">),</span> -</span><span id="L-426"><a href="#L-426"><span class="linenos">426</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Between</span><span class="p">:</span> <span class="n">_rename</span><span class="p">,</span> -</span><span id="L-427"><a href="#L-427"><span class="linenos">427</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Boolean</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="s2">"True"</span> <span class="k">if</span> <span class="n">e</span><span class="o">.</span><span class="n">this</span> <span class="k">else</span> <span class="s2">"False"</span><span class="p">,</span> -</span><span id="L-428"><a href="#L-428"><span class="linenos">428</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Cast</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"CAST(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">, exp.DataType.Type.</span><span class="si">{</span><span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="p">[</span><span class="s1">'to'</span><span class="p">]</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> -</span><span id="L-429"><a href="#L-429"><span class="linenos">429</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Column</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"scope[</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'table'</span><span class="p">)</span><span class="w"> </span><span class="ow">or</span><span class="w"> </span><span class="kc">None</span><span class="si">}</span><span class="s2">][</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">]"</span><span class="p">,</span> -</span><span id="L-430"><a href="#L-430"><span class="linenos">430</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Concat</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">func</span><span class="p">(</span> -</span><span id="L-431"><a href="#L-431"><span class="linenos">431</span></a> <span class="s2">"SAFECONCAT"</span> <span class="k">if</span> <span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="s2">"safe"</span><span class="p">)</span> <span class="k">else</span> <span class="s2">"CONCAT"</span><span class="p">,</span> <span class="o">*</span><span class="n">e</span><span class="o">.</span><span class="n">expressions</span> -</span><span id="L-432"><a href="#L-432"><span class="linenos">432</span></a> <span class="p">),</span> -</span><span id="L-433"><a href="#L-433"><span class="linenos">433</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Distinct</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"set(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'this'</span><span class="p">)</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> -</span><span id="L-434"><a href="#L-434"><span class="linenos">434</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Div</span><span class="p">:</span> <span class="n">_div_sql</span><span class="p">,</span> -</span><span id="L-435"><a href="#L-435"><span class="linenos">435</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Extract</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"EXTRACT('</span><span class="si">{</span><span class="n">e</span><span class="o">.</span><span class="n">name</span><span class="o">.</span><span class="n">lower</span><span class="p">()</span><span class="si">}</span><span class="s2">', </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'expression'</span><span class="p">)</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> -</span><span id="L-436"><a href="#L-436"><span class="linenos">436</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">In</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'this'</span><span class="p">)</span><span class="si">}</span><span class="s2"> in </span><span class="se">{{</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">expressions</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="n">flat</span><span class="o">=</span><span class="kc">True</span><span class="p">)</span><span class="si">}</span><span class="se">}}</span><span class="s2">"</span><span class="p">,</span> -</span><span id="L-437"><a href="#L-437"><span class="linenos">437</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Interval</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"INTERVAL(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">, '</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">unit</span><span class="p">)</span><span class="si">}</span><span class="s2">')"</span><span class="p">,</span> -</span><span id="L-438"><a href="#L-438"><span class="linenos">438</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Is</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"=="</span><span class="p">)</span> -</span><span id="L-439"><a href="#L-439"><span class="linenos">439</span></a> <span class="k">if</span> <span class="nb">isinstance</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">,</span> <span class="n">exp</span><span class="o">.</span><span class="n">Literal</span><span class="p">)</span> -</span><span id="L-440"><a href="#L-440"><span class="linenos">440</span></a> <span class="k">else</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"is"</span><span class="p">),</span> -</span><span id="L-441"><a href="#L-441"><span class="linenos">441</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Lambda</span><span class="p">:</span> <span class="n">_lambda_sql</span><span class="p">,</span> -</span><span id="L-442"><a href="#L-442"><span class="linenos">442</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Not</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"not </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">"</span><span class="p">,</span> -</span><span id="L-443"><a href="#L-443"><span class="linenos">443</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Null</span><span class="p">:</span> <span class="k">lambda</span> <span class="o">*</span><span class="n">_</span><span class="p">:</span> <span class="s2">"None"</span><span class="p">,</span> -</span><span id="L-444"><a href="#L-444"><span class="linenos">444</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Or</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"or"</span><span class="p">),</span> -</span><span id="L-445"><a href="#L-445"><span class="linenos">445</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Ordered</span><span class="p">:</span> <span class="n">_ordered_py</span><span class="p">,</span> -</span><span id="L-446"><a href="#L-446"><span class="linenos">446</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Star</span><span class="p">:</span> <span class="k">lambda</span> <span class="o">*</span><span class="n">_</span><span class="p">:</span> <span class="s2">"1"</span><span class="p">,</span> -</span><span id="L-447"><a href="#L-447"><span class="linenos">447</span></a> <span class="p">}</span> +</span><span id="L-414"><a href="#L-414"><span class="linenos">414</span></a> <span class="k">return</span> <span class="n">sql</span> +</span><span id="L-415"><a href="#L-415"><span class="linenos">415</span></a> +</span><span id="L-416"><a href="#L-416"><span class="linenos">416</span></a> +</span><span id="L-417"><a href="#L-417"><span class="linenos">417</span></a><span class="k">class</span> <span class="nc">Python</span><span class="p">(</span><span class="n">Dialect</span><span class="p">):</span> +</span><span id="L-418"><a href="#L-418"><span class="linenos">418</span></a> <span class="k">class</span> <span class="nc">Tokenizer</span><span class="p">(</span><span class="n">tokens</span><span class="o">.</span><span class="n">Tokenizer</span><span class="p">):</span> +</span><span id="L-419"><a href="#L-419"><span class="linenos">419</span></a> <span class="n">STRING_ESCAPES</span> <span class="o">=</span> <span class="p">[</span><span class="s2">"</span><span class="se">\\</span><span class="s2">"</span><span class="p">]</span> +</span><span id="L-420"><a href="#L-420"><span class="linenos">420</span></a> +</span><span id="L-421"><a href="#L-421"><span class="linenos">421</span></a> <span class="k">class</span> <span class="nc">Generator</span><span class="p">(</span><span class="n">generator</span><span class="o">.</span><span class="n">Generator</span><span class="p">):</span> +</span><span id="L-422"><a href="#L-422"><span class="linenos">422</span></a> <span class="n">TRANSFORMS</span> <span class="o">=</span> <span class="p">{</span> +</span><span id="L-423"><a href="#L-423"><span class="linenos">423</span></a> <span class="o">**</span><span class="p">{</span><span class="n">klass</span><span class="p">:</span> <span class="n">_rename</span> <span class="k">for</span> <span class="n">klass</span> <span class="ow">in</span> <span class="n">subclasses</span><span class="p">(</span><span class="n">exp</span><span class="o">.</span><span class="vm">__name__</span><span class="p">,</span> <span class="n">exp</span><span class="o">.</span><span class="n">Binary</span><span class="p">)},</span> +</span><span id="L-424"><a href="#L-424"><span class="linenos">424</span></a> <span class="o">**</span><span class="p">{</span><span class="n">klass</span><span class="p">:</span> <span class="n">_rename</span> <span class="k">for</span> <span class="n">klass</span> <span class="ow">in</span> <span class="n">exp</span><span class="o">.</span><span class="n">ALL_FUNCTIONS</span><span class="p">},</span> +</span><span id="L-425"><a href="#L-425"><span class="linenos">425</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Case</span><span class="p">:</span> <span class="n">_case_sql</span><span class="p">,</span> +</span><span id="L-426"><a href="#L-426"><span class="linenos">426</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Alias</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">),</span> +</span><span id="L-427"><a href="#L-427"><span class="linenos">427</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Array</span><span class="p">:</span> <span class="n">inline_array_sql</span><span class="p">,</span> +</span><span id="L-428"><a href="#L-428"><span class="linenos">428</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">And</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"and"</span><span class="p">),</span> +</span><span id="L-429"><a href="#L-429"><span class="linenos">429</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Between</span><span class="p">:</span> <span class="n">_rename</span><span class="p">,</span> +</span><span id="L-430"><a href="#L-430"><span class="linenos">430</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Boolean</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="s2">"True"</span> <span class="k">if</span> <span class="n">e</span><span class="o">.</span><span class="n">this</span> <span class="k">else</span> <span class="s2">"False"</span><span class="p">,</span> +</span><span id="L-431"><a href="#L-431"><span class="linenos">431</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Cast</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"CAST(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">, exp.DataType.Type.</span><span class="si">{</span><span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="p">[</span><span class="s1">'to'</span><span class="p">]</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> +</span><span id="L-432"><a href="#L-432"><span class="linenos">432</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Column</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"scope[</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'table'</span><span class="p">)</span><span class="w"> </span><span class="ow">or</span><span class="w"> </span><span class="kc">None</span><span class="si">}</span><span class="s2">][</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">]"</span><span class="p">,</span> +</span><span id="L-433"><a href="#L-433"><span class="linenos">433</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Concat</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">func</span><span class="p">(</span> +</span><span id="L-434"><a href="#L-434"><span class="linenos">434</span></a> <span class="s2">"SAFECONCAT"</span> <span class="k">if</span> <span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="s2">"safe"</span><span class="p">)</span> <span class="k">else</span> <span class="s2">"CONCAT"</span><span class="p">,</span> <span class="o">*</span><span class="n">e</span><span class="o">.</span><span class="n">expressions</span> +</span><span id="L-435"><a href="#L-435"><span class="linenos">435</span></a> <span class="p">),</span> +</span><span id="L-436"><a href="#L-436"><span class="linenos">436</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Distinct</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"set(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'this'</span><span class="p">)</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> +</span><span id="L-437"><a href="#L-437"><span class="linenos">437</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Div</span><span class="p">:</span> <span class="n">_div_sql</span><span class="p">,</span> +</span><span id="L-438"><a href="#L-438"><span class="linenos">438</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Extract</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"EXTRACT('</span><span class="si">{</span><span class="n">e</span><span class="o">.</span><span class="n">name</span><span class="o">.</span><span class="n">lower</span><span class="p">()</span><span class="si">}</span><span class="s2">', </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'expression'</span><span class="p">)</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> +</span><span id="L-439"><a href="#L-439"><span class="linenos">439</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">In</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'this'</span><span class="p">)</span><span class="si">}</span><span class="s2"> in </span><span class="se">{{</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">expressions</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="n">flat</span><span class="o">=</span><span class="kc">True</span><span class="p">)</span><span class="si">}</span><span class="se">}}</span><span class="s2">"</span><span class="p">,</span> +</span><span id="L-440"><a href="#L-440"><span class="linenos">440</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Interval</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"INTERVAL(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">, '</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">unit</span><span class="p">)</span><span class="si">}</span><span class="s2">')"</span><span class="p">,</span> +</span><span id="L-441"><a href="#L-441"><span class="linenos">441</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Is</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"=="</span><span class="p">)</span> +</span><span id="L-442"><a href="#L-442"><span class="linenos">442</span></a> <span class="k">if</span> <span class="nb">isinstance</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">,</span> <span class="n">exp</span><span class="o">.</span><span class="n">Literal</span><span class="p">)</span> +</span><span id="L-443"><a href="#L-443"><span class="linenos">443</span></a> <span class="k">else</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"is"</span><span class="p">),</span> +</span><span id="L-444"><a href="#L-444"><span class="linenos">444</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Lambda</span><span class="p">:</span> <span class="n">_lambda_sql</span><span class="p">,</span> +</span><span id="L-445"><a href="#L-445"><span class="linenos">445</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Not</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"not </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">"</span><span class="p">,</span> +</span><span id="L-446"><a href="#L-446"><span class="linenos">446</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Null</span><span class="p">:</span> <span class="k">lambda</span> <span class="o">*</span><span class="n">_</span><span class="p">:</span> <span class="s2">"None"</span><span class="p">,</span> +</span><span id="L-447"><a href="#L-447"><span class="linenos">447</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Or</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"or"</span><span class="p">),</span> +</span><span id="L-448"><a href="#L-448"><span class="linenos">448</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Ordered</span><span class="p">:</span> <span class="n">_ordered_py</span><span class="p">,</span> +</span><span id="L-449"><a href="#L-449"><span class="linenos">449</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Star</span><span class="p">:</span> <span class="k">lambda</span> <span class="o">*</span><span class="n">_</span><span class="p">:</span> <span class="s2">"1"</span><span class="p">,</span> +</span><span id="L-450"><a href="#L-450"><span class="linenos">450</span></a> <span class="p">}</span> </span></pre></div> @@ -990,7 +993,10 @@ </span><span id="PythonExecutor-344"><a href="#PythonExecutor-344"><span class="linenos">344</span></a> <span class="k">else</span><span class="p">:</span> </span><span id="PythonExecutor-345"><a href="#PythonExecutor-345"><span class="linenos">345</span></a> <span class="n">sink</span><span class="o">.</span><span class="n">rows</span> <span class="o">=</span> <span class="n">left</span><span class="o">.</span><span class="n">rows</span> <span class="o">+</span> <span class="n">right</span><span class="o">.</span><span class="n">rows</span> </span><span id="PythonExecutor-346"><a href="#PythonExecutor-346"><span class="linenos">346</span></a> -</span><span id="PythonExecutor-347"><a href="#PythonExecutor-347"><span class="linenos">347</span></a> <span class="k">return</span> <span class="bp">self</span><span class="o">.</span><span class="n">context</span><span class="p">({</span><span class="n">step</span><span class="o">.</span><span class="n">name</span><span class="p">:</span> <span class="n">sink</span><span class="p">})</span> +</span><span id="PythonExecutor-347"><a href="#PythonExecutor-347"><span class="linenos">347</span></a> <span class="k">if</span> <span class="ow">not</span> <span class="n">math</span><span class="o">.</span><span class="n">isinf</span><span class="p">(</span><span class="n">step</span><span class="o">.</span><span class="n">limit</span><span class="p">):</span> +</span><span id="PythonExecutor-348"><a href="#PythonExecutor-348"><span class="linenos">348</span></a> <span class="n">sink</span><span class="o">.</span><span class="n">rows</span> <span class="o">=</span> <span class="n">sink</span><span class="o">.</span><span class="n">rows</span><span class="p">[</span><span class="mi">0</span> <span class="p">:</span> <span class="n">step</span><span class="o">.</span><span class="n">limit</span><span class="p">]</span> +</span><span id="PythonExecutor-349"><a href="#PythonExecutor-349"><span class="linenos">349</span></a> +</span><span id="PythonExecutor-350"><a href="#PythonExecutor-350"><span class="linenos">350</span></a> <span class="k">return</span> <span class="bp">self</span><span class="o">.</span><span class="n">context</span><span class="p">({</span><span class="n">step</span><span class="o">.</span><span class="n">name</span><span class="p">:</span> <span class="n">sink</span><span class="p">})</span> </span></pre></div> @@ -1594,7 +1600,10 @@ </span><span id="PythonExecutor.set_operation-344"><a href="#PythonExecutor.set_operation-344"><span class="linenos">344</span></a> <span class="k">else</span><span class="p">:</span> </span><span id="PythonExecutor.set_operation-345"><a href="#PythonExecutor.set_operation-345"><span class="linenos">345</span></a> <span class="n">sink</span><span class="o">.</span><span class="n">rows</span> <span class="o">=</span> <span class="n">left</span><span class="o">.</span><span class="n">rows</span> <span class="o">+</span> <span class="n">right</span><span class="o">.</span><span class="n">rows</span> </span><span id="PythonExecutor.set_operation-346"><a href="#PythonExecutor.set_operation-346"><span class="linenos">346</span></a> -</span><span id="PythonExecutor.set_operation-347"><a href="#PythonExecutor.set_operation-347"><span class="linenos">347</span></a> <span class="k">return</span> <span class="bp">self</span><span class="o">.</span><span class="n">context</span><span class="p">({</span><span class="n">step</span><span class="o">.</span><span class="n">name</span><span class="p">:</span> <span class="n">sink</span><span class="p">})</span> +</span><span id="PythonExecutor.set_operation-347"><a href="#PythonExecutor.set_operation-347"><span class="linenos">347</span></a> <span class="k">if</span> <span class="ow">not</span> <span class="n">math</span><span class="o">.</span><span class="n">isinf</span><span class="p">(</span><span class="n">step</span><span class="o">.</span><span class="n">limit</span><span class="p">):</span> +</span><span id="PythonExecutor.set_operation-348"><a href="#PythonExecutor.set_operation-348"><span class="linenos">348</span></a> <span class="n">sink</span><span class="o">.</span><span class="n">rows</span> <span class="o">=</span> <span class="n">sink</span><span class="o">.</span><span class="n">rows</span><span class="p">[</span><span class="mi">0</span> <span class="p">:</span> <span class="n">step</span><span class="o">.</span><span class="n">limit</span><span class="p">]</span> +</span><span id="PythonExecutor.set_operation-349"><a href="#PythonExecutor.set_operation-349"><span class="linenos">349</span></a> +</span><span id="PythonExecutor.set_operation-350"><a href="#PythonExecutor.set_operation-350"><span class="linenos">350</span></a> <span class="k">return</span> <span class="bp">self</span><span class="o">.</span><span class="n">context</span><span class="p">({</span><span class="n">step</span><span class="o">.</span><span class="n">name</span><span class="p">:</span> <span class="n">sink</span><span class="p">})</span> </span></pre></div> @@ -1613,40 +1622,40 @@ </div> <a class="headerlink" href="#Python"></a> - <div class="pdoc-code codehilite"><pre><span></span><span id="Python-415"><a href="#Python-415"><span class="linenos">415</span></a><span class="k">class</span> <span class="nc">Python</span><span class="p">(</span><span class="n">Dialect</span><span class="p">):</span> -</span><span id="Python-416"><a href="#Python-416"><span class="linenos">416</span></a> <span class="k">class</span> <span class="nc">Tokenizer</span><span class="p">(</span><span class="n">tokens</span><span class="o">.</span><span class="n">Tokenizer</span><span class="p">):</span> -</span><span id="Python-417"><a href="#Python-417"><span class="linenos">417</span></a> <span class="n">STRING_ESCAPES</span> <span class="o">=</span> <span class="p">[</span><span class="s2">"</span><span class="se">\\</span><span class="s2">"</span><span class="p">]</span> -</span><span id="Python-418"><a href="#Python-418"><span class="linenos">418</span></a> -</span><span id="Python-419"><a href="#Python-419"><span class="linenos">419</span></a> <span class="k">class</span> <span class="nc">Generator</span><span class="p">(</span><span class="n">generator</span><span class="o">.</span><span class="n">Generator</span><span class="p">):</span> -</span><span id="Python-420"><a href="#Python-420"><span class="linenos">420</span></a> <span class="n">TRANSFORMS</span> <span class="o">=</span> <span class="p">{</span> -</span><span id="Python-421"><a href="#Python-421"><span class="linenos">421</span></a> <span class="o">**</span><span class="p">{</span><span class="n">klass</span><span class="p">:</span> <span class="n">_rename</span> <span class="k">for</span> <span class="n">klass</span> <span class="ow">in</span> <span class="n">subclasses</span><span class="p">(</span><span class="n">exp</span><span class="o">.</span><span class="vm">__name__</span><span class="p">,</span> <span class="n">exp</span><span class="o">.</span><span class="n">Binary</span><span class="p">)},</span> -</span><span id="Python-422"><a href="#Python-422"><span class="linenos">422</span></a> <span class="o">**</span><span class="p">{</span><span class="n">klass</span><span class="p">:</span> <span class="n">_rename</span> <span class="k">for</span> <span class="n">klass</span> <span class="ow">in</span> <span class="n">exp</span><span class="o">.</span><span class="n">ALL_FUNCTIONS</span><span class="p">},</span> -</span><span id="Python-423"><a href="#Python-423"><span class="linenos">423</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Case</span><span class="p">:</span> <span class="n">_case_sql</span><span class="p">,</span> -</span><span id="Python-424"><a href="#Python-424"><span class="linenos">424</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Alias</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">),</span> -</span><span id="Python-425"><a href="#Python-425"><span class="linenos">425</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Array</span><span class="p">:</span> <span class="n">inline_array_sql</span><span class="p">,</span> -</span><span id="Python-426"><a href="#Python-426"><span class="linenos">426</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">And</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"and"</span><span class="p">),</span> -</span><span id="Python-427"><a href="#Python-427"><span class="linenos">427</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Between</span><span class="p">:</span> <span class="n">_rename</span><span class="p">,</span> -</span><span id="Python-428"><a href="#Python-428"><span class="linenos">428</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Boolean</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="s2">"True"</span> <span class="k">if</span> <span class="n">e</span><span class="o">.</span><span class="n">this</span> <span class="k">else</span> <span class="s2">"False"</span><span class="p">,</span> -</span><span id="Python-429"><a href="#Python-429"><span class="linenos">429</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Cast</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"CAST(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">, exp.DataType.Type.</span><span class="si">{</span><span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="p">[</span><span class="s1">'to'</span><span class="p">]</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> -</span><span id="Python-430"><a href="#Python-430"><span class="linenos">430</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Column</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"scope[</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'table'</span><span class="p">)</span><span class="w"> </span><span class="ow">or</span><span class="w"> </span><span class="kc">None</span><span class="si">}</span><span class="s2">][</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">]"</span><span class="p">,</span> -</span><span id="Python-431"><a href="#Python-431"><span class="linenos">431</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Concat</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">func</span><span class="p">(</span> -</span><span id="Python-432"><a href="#Python-432"><span class="linenos">432</span></a> <span class="s2">"SAFECONCAT"</span> <span class="k">if</span> <span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="s2">"safe"</span><span class="p">)</span> <span class="k">else</span> <span class="s2">"CONCAT"</span><span class="p">,</span> <span class="o">*</span><span class="n">e</span><span class="o">.</span><span class="n">expressions</span> -</span><span id="Python-433"><a href="#Python-433"><span class="linenos">433</span></a> <span class="p">),</span> -</span><span id="Python-434"><a href="#Python-434"><span class="linenos">434</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Distinct</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"set(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'this'</span><span class="p">)</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> -</span><span id="Python-435"><a href="#Python-435"><span class="linenos">435</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Div</span><span class="p">:</span> <span class="n">_div_sql</span><span class="p">,</span> -</span><span id="Python-436"><a href="#Python-436"><span class="linenos">436</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Extract</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"EXTRACT('</span><span class="si">{</span><span class="n">e</span><span class="o">.</span><span class="n">name</span><span class="o">.</span><span class="n">lower</span><span class="p">()</span><span class="si">}</span><span class="s2">', </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'expression'</span><span class="p">)</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> -</span><span id="Python-437"><a href="#Python-437"><span class="linenos">437</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">In</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'this'</span><span class="p">)</span><span class="si">}</span><span class="s2"> in </span><span class="se">{{</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">expressions</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="n">flat</span><span class="o">=</span><span class="kc">True</span><span class="p">)</span><span class="si">}</span><span class="se">}}</span><span class="s2">"</span><span class="p">,</span> -</span><span id="Python-438"><a href="#Python-438"><span class="linenos">438</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Interval</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"INTERVAL(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">, '</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">unit</span><span class="p">)</span><span class="si">}</span><span class="s2">')"</span><span class="p">,</span> -</span><span id="Python-439"><a href="#Python-439"><span class="linenos">439</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Is</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"=="</span><span class="p">)</span> -</span><span id="Python-440"><a href="#Python-440"><span class="linenos">440</span></a> <span class="k">if</span> <span class="nb">isinstance</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">,</span> <span class="n">exp</span><span class="o">.</span><span class="n">Literal</span><span class="p">)</span> -</span><span id="Python-441"><a href="#Python-441"><span class="linenos">441</span></a> <span class="k">else</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"is"</span><span class="p">),</span> -</span><span id="Python-442"><a href="#Python-442"><span class="linenos">442</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Lambda</span><span class="p">:</span> <span class="n">_lambda_sql</span><span class="p">,</span> -</span><span id="Python-443"><a href="#Python-443"><span class="linenos">443</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Not</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"not </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">"</span><span class="p">,</span> -</span><span id="Python-444"><a href="#Python-444"><span class="linenos">444</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Null</span><span class="p">:</span> <span class="k">lambda</span> <span class="o">*</span><span class="n">_</span><span class="p">:</span> <span class="s2">"None"</span><span class="p">,</span> -</span><span id="Python-445"><a href="#Python-445"><span class="linenos">445</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Or</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"or"</span><span class="p">),</span> -</span><span id="Python-446"><a href="#Python-446"><span class="linenos">446</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Ordered</span><span class="p">:</span> <span class="n">_ordered_py</span><span class="p">,</span> -</span><span id="Python-447"><a href="#Python-447"><span class="linenos">447</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Star</span><span class="p">:</span> <span class="k">lambda</span> <span class="o">*</span><span class="n">_</span><span class="p">:</span> <span class="s2">"1"</span><span class="p">,</span> -</span><span id="Python-448"><a href="#Python-448"><span class="linenos">448</span></a> <span class="p">}</span> + <div class="pdoc-code codehilite"><pre><span></span><span id="Python-418"><a href="#Python-418"><span class="linenos">418</span></a><span class="k">class</span> <span class="nc">Python</span><span class="p">(</span><span class="n">Dialect</span><span class="p">):</span> +</span><span id="Python-419"><a href="#Python-419"><span class="linenos">419</span></a> <span class="k">class</span> <span class="nc">Tokenizer</span><span class="p">(</span><span class="n">tokens</span><span class="o">.</span><span class="n">Tokenizer</span><span class="p">):</span> +</span><span id="Python-420"><a href="#Python-420"><span class="linenos">420</span></a> <span class="n">STRING_ESCAPES</span> <span class="o">=</span> <span class="p">[</span><span class="s2">"</span><span class="se">\\</span><span class="s2">"</span><span class="p">]</span> +</span><span id="Python-421"><a href="#Python-421"><span class="linenos">421</span></a> +</span><span id="Python-422"><a href="#Python-422"><span class="linenos">422</span></a> <span class="k">class</span> <span class="nc">Generator</span><span class="p">(</span><span class="n">generator</span><span class="o">.</span><span class="n">Generator</span><span class="p">):</span> +</span><span id="Python-423"><a href="#Python-423"><span class="linenos">423</span></a> <span class="n">TRANSFORMS</span> <span class="o">=</span> <span class="p">{</span> +</span><span id="Python-424"><a href="#Python-424"><span class="linenos">424</span></a> <span class="o">**</span><span class="p">{</span><span class="n">klass</span><span class="p">:</span> <span class="n">_rename</span> <span class="k">for</span> <span class="n">klass</span> <span class="ow">in</span> <span class="n">subclasses</span><span class="p">(</span><span class="n">exp</span><span class="o">.</span><span class="vm">__name__</span><span class="p">,</span> <span class="n">exp</span><span class="o">.</span><span class="n">Binary</span><span class="p">)},</span> +</span><span id="Python-425"><a href="#Python-425"><span class="linenos">425</span></a> <span class="o">**</span><span class="p">{</span><span class="n">klass</span><span class="p">:</span> <span class="n">_rename</span> <span class="k">for</span> <span class="n">klass</span> <span class="ow">in</span> <span class="n">exp</span><span class="o">.</span><span class="n">ALL_FUNCTIONS</span><span class="p">},</span> +</span><span id="Python-426"><a href="#Python-426"><span class="linenos">426</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Case</span><span class="p">:</span> <span class="n">_case_sql</span><span class="p">,</span> +</span><span id="Python-427"><a href="#Python-427"><span class="linenos">427</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Alias</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">),</span> +</span><span id="Python-428"><a href="#Python-428"><span class="linenos">428</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Array</span><span class="p">:</span> <span class="n">inline_array_sql</span><span class="p">,</span> +</span><span id="Python-429"><a href="#Python-429"><span class="linenos">429</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">And</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"and"</span><span class="p">),</span> +</span><span id="Python-430"><a href="#Python-430"><span class="linenos">430</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Between</span><span class="p">:</span> <span class="n">_rename</span><span class="p">,</span> +</span><span id="Python-431"><a href="#Python-431"><span class="linenos">431</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Boolean</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="s2">"True"</span> <span class="k">if</span> <span class="n">e</span><span class="o">.</span><span class="n">this</span> <span class="k">else</span> <span class="s2">"False"</span><span class="p">,</span> +</span><span id="Python-432"><a href="#Python-432"><span class="linenos">432</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Cast</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"CAST(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">, exp.DataType.Type.</span><span class="si">{</span><span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="p">[</span><span class="s1">'to'</span><span class="p">]</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> +</span><span id="Python-433"><a href="#Python-433"><span class="linenos">433</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Column</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"scope[</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'table'</span><span class="p">)</span><span class="w"> </span><span class="ow">or</span><span class="w"> </span><span class="kc">None</span><span class="si">}</span><span class="s2">][</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">]"</span><span class="p">,</span> +</span><span id="Python-434"><a href="#Python-434"><span class="linenos">434</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Concat</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">func</span><span class="p">(</span> +</span><span id="Python-435"><a href="#Python-435"><span class="linenos">435</span></a> <span class="s2">"SAFECONCAT"</span> <span class="k">if</span> <span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="s2">"safe"</span><span class="p">)</span> <span class="k">else</span> <span class="s2">"CONCAT"</span><span class="p">,</span> <span class="o">*</span><span class="n">e</span><span class="o">.</span><span class="n">expressions</span> +</span><span id="Python-436"><a href="#Python-436"><span class="linenos">436</span></a> <span class="p">),</span> +</span><span id="Python-437"><a href="#Python-437"><span class="linenos">437</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Distinct</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"set(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'this'</span><span class="p">)</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> +</span><span id="Python-438"><a href="#Python-438"><span class="linenos">438</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Div</span><span class="p">:</span> <span class="n">_div_sql</span><span class="p">,</span> +</span><span id="Python-439"><a href="#Python-439"><span class="linenos">439</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Extract</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"EXTRACT('</span><span class="si">{</span><span class="n">e</span><span class="o">.</span><span class="n">name</span><span class="o">.</span><span class="n">lower</span><span class="p">()</span><span class="si">}</span><span class="s2">', </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'expression'</span><span class="p">)</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> +</span><span id="Python-440"><a href="#Python-440"><span class="linenos">440</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">In</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'this'</span><span class="p">)</span><span class="si">}</span><span class="s2"> in </span><span class="se">{{</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">expressions</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="n">flat</span><span class="o">=</span><span class="kc">True</span><span class="p">)</span><span class="si">}</span><span class="se">}}</span><span class="s2">"</span><span class="p">,</span> +</span><span id="Python-441"><a href="#Python-441"><span class="linenos">441</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Interval</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"INTERVAL(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">, '</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">unit</span><span class="p">)</span><span class="si">}</span><span class="s2">')"</span><span class="p">,</span> +</span><span id="Python-442"><a href="#Python-442"><span class="linenos">442</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Is</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"=="</span><span class="p">)</span> +</span><span id="Python-443"><a href="#Python-443"><span class="linenos">443</span></a> <span class="k">if</span> <span class="nb">isinstance</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">,</span> <span class="n">exp</span><span class="o">.</span><span class="n">Literal</span><span class="p">)</span> +</span><span id="Python-444"><a href="#Python-444"><span class="linenos">444</span></a> <span class="k">else</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"is"</span><span class="p">),</span> +</span><span id="Python-445"><a href="#Python-445"><span class="linenos">445</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Lambda</span><span class="p">:</span> <span class="n">_lambda_sql</span><span class="p">,</span> +</span><span id="Python-446"><a href="#Python-446"><span class="linenos">446</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Not</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"not </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">"</span><span class="p">,</span> +</span><span id="Python-447"><a href="#Python-447"><span class="linenos">447</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Null</span><span class="p">:</span> <span class="k">lambda</span> <span class="o">*</span><span class="n">_</span><span class="p">:</span> <span class="s2">"None"</span><span class="p">,</span> +</span><span id="Python-448"><a href="#Python-448"><span class="linenos">448</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Or</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"or"</span><span class="p">),</span> +</span><span id="Python-449"><a href="#Python-449"><span class="linenos">449</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Ordered</span><span class="p">:</span> <span class="n">_ordered_py</span><span class="p">,</span> +</span><span id="Python-450"><a href="#Python-450"><span class="linenos">450</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Star</span><span class="p">:</span> <span class="k">lambda</span> <span class="o">*</span><span class="n">_</span><span class="p">:</span> <span class="s2">"1"</span><span class="p">,</span> +</span><span id="Python-451"><a href="#Python-451"><span class="linenos">451</span></a> <span class="p">}</span> </span></pre></div> @@ -1887,6 +1896,7 @@ <dd id="Python.NULL_ORDERING" class="variable"><a href="../dialects/dialect.html#Dialect.NULL_ORDERING">NULL_ORDERING</a></dd> <dd id="Python.TYPED_DIVISION" class="variable"><a href="../dialects/dialect.html#Dialect.TYPED_DIVISION">TYPED_DIVISION</a></dd> <dd id="Python.SAFE_DIVISION" class="variable"><a href="../dialects/dialect.html#Dialect.SAFE_DIVISION">SAFE_DIVISION</a></dd> + <dd id="Python.CONCAT_COALESCE" class="variable"><a href="../dialects/dialect.html#Dialect.CONCAT_COALESCE">CONCAT_COALESCE</a></dd> <dd id="Python.DATE_FORMAT" class="variable"><a href="../dialects/dialect.html#Dialect.DATE_FORMAT">DATE_FORMAT</a></dd> <dd id="Python.DATEINT_FORMAT" class="variable"><a href="../dialects/dialect.html#Dialect.DATEINT_FORMAT">DATEINT_FORMAT</a></dd> <dd id="Python.TIME_FORMAT" class="variable"><a href="../dialects/dialect.html#Dialect.TIME_FORMAT">TIME_FORMAT</a></dd> @@ -1924,8 +1934,8 @@ </div> <a class="headerlink" href="#Python.Tokenizer"></a> - <div class="pdoc-code codehilite"><pre><span></span><span id="Python.Tokenizer-416"><a href="#Python.Tokenizer-416"><span class="linenos">416</span></a> <span class="k">class</span> <span class="nc">Tokenizer</span><span class="p">(</span><span class="n">tokens</span><span class="o">.</span><span class="n">Tokenizer</span><span class="p">):</span> -</span><span id="Python.Tokenizer-417"><a href="#Python.Tokenizer-417"><span class="linenos">417</span></a> <span class="n">STRING_ESCAPES</span> <span class="o">=</span> <span class="p">[</span><span class="s2">"</span><span class="se">\\</span><span class="s2">"</span><span class="p">]</span> + <div class="pdoc-code codehilite"><pre><span></span><span id="Python.Tokenizer-419"><a href="#Python.Tokenizer-419"><span class="linenos">419</span></a> <span class="k">class</span> <span class="nc">Tokenizer</span><span class="p">(</span><span class="n">tokens</span><span class="o">.</span><span class="n">Tokenizer</span><span class="p">):</span> +</span><span id="Python.Tokenizer-420"><a href="#Python.Tokenizer-420"><span class="linenos">420</span></a> <span class="n">STRING_ESCAPES</span> <span class="o">=</span> <span class="p">[</span><span class="s2">"</span><span class="se">\\</span><span class="s2">"</span><span class="p">]</span> </span></pre></div> @@ -1963,12 +1973,12 @@ <dd id="Python.Tokenizer.COMMANDS" class="variable"><a href="../tokens.html#Tokenizer.COMMANDS">COMMANDS</a></dd> <dd id="Python.Tokenizer.COMMAND_PREFIX_TOKENS" class="variable"><a href="../tokens.html#Tokenizer.COMMAND_PREFIX_TOKENS">COMMAND_PREFIX_TOKENS</a></dd> <dd id="Python.Tokenizer.NUMERIC_LITERALS" class="variable"><a href="../tokens.html#Tokenizer.NUMERIC_LITERALS">NUMERIC_LITERALS</a></dd> - <dd id="Python.Tokenizer.ENCODE" class="variable"><a href="../tokens.html#Tokenizer.ENCODE">ENCODE</a></dd> <dd id="Python.Tokenizer.COMMENTS" class="variable"><a href="../tokens.html#Tokenizer.COMMENTS">COMMENTS</a></dd> <dd id="Python.Tokenizer.dialect" class="variable"><a href="../tokens.html#Tokenizer.dialect">dialect</a></dd> <dd id="Python.Tokenizer.reset" class="function"><a href="../tokens.html#Tokenizer.reset">reset</a></dd> <dd id="Python.Tokenizer.tokenize" class="function"><a href="../tokens.html#Tokenizer.tokenize">tokenize</a></dd> <dd id="Python.Tokenizer.peek" class="function"><a href="../tokens.html#Tokenizer.peek">peek</a></dd> + <dd id="Python.Tokenizer.tokenize_rs" class="function"><a href="../tokens.html#Tokenizer.tokenize_rs">tokenize_rs</a></dd> <dd id="Python.Tokenizer.size" class="variable"><a href="../tokens.html#Tokenizer.size">size</a></dd> <dd id="Python.Tokenizer.sql" class="variable"><a href="../tokens.html#Tokenizer.sql">sql</a></dd> <dd id="Python.Tokenizer.tokens" class="variable"><a href="../tokens.html#Tokenizer.tokens">tokens</a></dd> @@ -1988,36 +1998,36 @@ </div> <a class="headerlink" href="#Python.Generator"></a> - <div class="pdoc-code codehilite"><pre><span></span><span id="Python.Generator-419"><a href="#Python.Generator-419"><span class="linenos">419</span></a> <span class="k">class</span> <span class="nc">Generator</span><span class="p">(</span><span class="n">generator</span><span class="o">.</span><span class="n">Generator</span><span class="p">):</span> -</span><span id="Python.Generator-420"><a href="#Python.Generator-420"><span class="linenos">420</span></a> <span class="n">TRANSFORMS</span> <span class="o">=</span> <span class="p">{</span> -</span><span id="Python.Generator-421"><a href="#Python.Generator-421"><span class="linenos">421</span></a> <span class="o">**</span><span class="p">{</span><span class="n">klass</span><span class="p">:</span> <span class="n">_rename</span> <span class="k">for</span> <span class="n">klass</span> <span class="ow">in</span> <span class="n">subclasses</span><span class="p">(</span><span class="n">exp</span><span class="o">.</span><span class="vm">__name__</span><span class="p">,</span> <span class="n">exp</span><span class="o">.</span><span class="n">Binary</span><span class="p">)},</span> -</span><span id="Python.Generator-422"><a href="#Python.Generator-422"><span class="linenos">422</span></a> <span class="o">**</span><span class="p">{</span><span class="n">klass</span><span class="p">:</span> <span class="n">_rename</span> <span class="k">for</span> <span class="n">klass</span> <span class="ow">in</span> <span class="n">exp</span><span class="o">.</span><span class="n">ALL_FUNCTIONS</span><span class="p">},</span> -</span><span id="Python.Generator-423"><a href="#Python.Generator-423"><span class="linenos">423</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Case</span><span class="p">:</span> <span class="n">_case_sql</span><span class="p">,</span> -</span><span id="Python.Generator-424"><a href="#Python.Generator-424"><span class="linenos">424</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Alias</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">),</span> -</span><span id="Python.Generator-425"><a href="#Python.Generator-425"><span class="linenos">425</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Array</span><span class="p">:</span> <span class="n">inline_array_sql</span><span class="p">,</span> -</span><span id="Python.Generator-426"><a href="#Python.Generator-426"><span class="linenos">426</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">And</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"and"</span><span class="p">),</span> -</span><span id="Python.Generator-427"><a href="#Python.Generator-427"><span class="linenos">427</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Between</span><span class="p">:</span> <span class="n">_rename</span><span class="p">,</span> -</span><span id="Python.Generator-428"><a href="#Python.Generator-428"><span class="linenos">428</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Boolean</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="s2">"True"</span> <span class="k">if</span> <span class="n">e</span><span class="o">.</span><span class="n">this</span> <span class="k">else</span> <span class="s2">"False"</span><span class="p">,</span> -</span><span id="Python.Generator-429"><a href="#Python.Generator-429"><span class="linenos">429</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Cast</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"CAST(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">, exp.DataType.Type.</span><span class="si">{</span><span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="p">[</span><span class="s1">'to'</span><span class="p">]</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> -</span><span id="Python.Generator-430"><a href="#Python.Generator-430"><span class="linenos">430</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Column</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"scope[</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'table'</span><span class="p">)</span><span class="w"> </span><span class="ow">or</span><span class="w"> </span><span class="kc">None</span><span class="si">}</span><span class="s2">][</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">]"</span><span class="p">,</span> -</span><span id="Python.Generator-431"><a href="#Python.Generator-431"><span class="linenos">431</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Concat</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">func</span><span class="p">(</span> -</span><span id="Python.Generator-432"><a href="#Python.Generator-432"><span class="linenos">432</span></a> <span class="s2">"SAFECONCAT"</span> <span class="k">if</span> <span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="s2">"safe"</span><span class="p">)</span> <span class="k">else</span> <span class="s2">"CONCAT"</span><span class="p">,</span> <span class="o">*</span><span class="n">e</span><span class="o">.</span><span class="n">expressions</span> -</span><span id="Python.Generator-433"><a href="#Python.Generator-433"><span class="linenos">433</span></a> <span class="p">),</span> -</span><span id="Python.Generator-434"><a href="#Python.Generator-434"><span class="linenos">434</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Distinct</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"set(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'this'</span><span class="p">)</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> -</span><span id="Python.Generator-435"><a href="#Python.Generator-435"><span class="linenos">435</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Div</span><span class="p">:</span> <span class="n">_div_sql</span><span class="p">,</span> -</span><span id="Python.Generator-436"><a href="#Python.Generator-436"><span class="linenos">436</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Extract</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"EXTRACT('</span><span class="si">{</span><span class="n">e</span><span class="o">.</span><span class="n">name</span><span class="o">.</span><span class="n">lower</span><span class="p">()</span><span class="si">}</span><span class="s2">', </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'expression'</span><span class="p">)</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> -</span><span id="Python.Generator-437"><a href="#Python.Generator-437"><span class="linenos">437</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">In</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'this'</span><span class="p">)</span><span class="si">}</span><span class="s2"> in </span><span class="se">{{</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">expressions</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="n">flat</span><span class="o">=</span><span class="kc">True</span><span class="p">)</span><span class="si">}</span><span class="se">}}</span><span class="s2">"</span><span class="p">,</span> -</span><span id="Python.Generator-438"><a href="#Python.Generator-438"><span class="linenos">438</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Interval</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"INTERVAL(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">, '</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">unit</span><span class="p">)</span><span class="si">}</span><span class="s2">')"</span><span class="p">,</span> -</span><span id="Python.Generator-439"><a href="#Python.Generator-439"><span class="linenos">439</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Is</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"=="</span><span class="p">)</span> -</span><span id="Python.Generator-440"><a href="#Python.Generator-440"><span class="linenos">440</span></a> <span class="k">if</span> <span class="nb">isinstance</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">,</span> <span class="n">exp</span><span class="o">.</span><span class="n">Literal</span><span class="p">)</span> -</span><span id="Python.Generator-441"><a href="#Python.Generator-441"><span class="linenos">441</span></a> <span class="k">else</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"is"</span><span class="p">),</span> -</span><span id="Python.Generator-442"><a href="#Python.Generator-442"><span class="linenos">442</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Lambda</span><span class="p">:</span> <span class="n">_lambda_sql</span><span class="p">,</span> -</span><span id="Python.Generator-443"><a href="#Python.Generator-443"><span class="linenos">443</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Not</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"not </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">"</span><span class="p">,</span> -</span><span id="Python.Generator-444"><a href="#Python.Generator-444"><span class="linenos">444</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Null</span><span class="p">:</span> <span class="k">lambda</span> <span class="o">*</span><span class="n">_</span><span class="p">:</span> <span class="s2">"None"</span><span class="p">,</span> -</span><span id="Python.Generator-445"><a href="#Python.Generator-445"><span class="linenos">445</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Or</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"or"</span><span class="p">),</span> -</span><span id="Python.Generator-446"><a href="#Python.Generator-446"><span class="linenos">446</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Ordered</span><span class="p">:</span> <span class="n">_ordered_py</span><span class="p">,</span> -</span><span id="Python.Generator-447"><a href="#Python.Generator-447"><span class="linenos">447</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Star</span><span class="p">:</span> <span class="k">lambda</span> <span class="o">*</span><span class="n">_</span><span class="p">:</span> <span class="s2">"1"</span><span class="p">,</span> -</span><span id="Python.Generator-448"><a href="#Python.Generator-448"><span class="linenos">448</span></a> <span class="p">}</span> + <div class="pdoc-code codehilite"><pre><span></span><span id="Python.Generator-422"><a href="#Python.Generator-422"><span class="linenos">422</span></a> <span class="k">class</span> <span class="nc">Generator</span><span class="p">(</span><span class="n">generator</span><span class="o">.</span><span class="n">Generator</span><span class="p">):</span> +</span><span id="Python.Generator-423"><a href="#Python.Generator-423"><span class="linenos">423</span></a> <span class="n">TRANSFORMS</span> <span class="o">=</span> <span class="p">{</span> +</span><span id="Python.Generator-424"><a href="#Python.Generator-424"><span class="linenos">424</span></a> <span class="o">**</span><span class="p">{</span><span class="n">klass</span><span class="p">:</span> <span class="n">_rename</span> <span class="k">for</span> <span class="n">klass</span> <span class="ow">in</span> <span class="n">subclasses</span><span class="p">(</span><span class="n">exp</span><span class="o">.</span><span class="vm">__name__</span><span class="p">,</span> <span class="n">exp</span><span class="o">.</span><span class="n">Binary</span><span class="p">)},</span> +</span><span id="Python.Generator-425"><a href="#Python.Generator-425"><span class="linenos">425</span></a> <span class="o">**</span><span class="p">{</span><span class="n">klass</span><span class="p">:</span> <span class="n">_rename</span> <span class="k">for</span> <span class="n">klass</span> <span class="ow">in</span> <span class="n">exp</span><span class="o">.</span><span class="n">ALL_FUNCTIONS</span><span class="p">},</span> +</span><span id="Python.Generator-426"><a href="#Python.Generator-426"><span class="linenos">426</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Case</span><span class="p">:</span> <span class="n">_case_sql</span><span class="p">,</span> +</span><span id="Python.Generator-427"><a href="#Python.Generator-427"><span class="linenos">427</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Alias</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">),</span> +</span><span id="Python.Generator-428"><a href="#Python.Generator-428"><span class="linenos">428</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Array</span><span class="p">:</span> <span class="n">inline_array_sql</span><span class="p">,</span> +</span><span id="Python.Generator-429"><a href="#Python.Generator-429"><span class="linenos">429</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">And</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"and"</span><span class="p">),</span> +</span><span id="Python.Generator-430"><a href="#Python.Generator-430"><span class="linenos">430</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Between</span><span class="p">:</span> <span class="n">_rename</span><span class="p">,</span> +</span><span id="Python.Generator-431"><a href="#Python.Generator-431"><span class="linenos">431</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Boolean</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="s2">"True"</span> <span class="k">if</span> <span class="n">e</span><span class="o">.</span><span class="n">this</span> <span class="k">else</span> <span class="s2">"False"</span><span class="p">,</span> +</span><span id="Python.Generator-432"><a href="#Python.Generator-432"><span class="linenos">432</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Cast</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"CAST(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">, exp.DataType.Type.</span><span class="si">{</span><span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="p">[</span><span class="s1">'to'</span><span class="p">]</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> +</span><span id="Python.Generator-433"><a href="#Python.Generator-433"><span class="linenos">433</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Column</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"scope[</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'table'</span><span class="p">)</span><span class="w"> </span><span class="ow">or</span><span class="w"> </span><span class="kc">None</span><span class="si">}</span><span class="s2">][</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">]"</span><span class="p">,</span> +</span><span id="Python.Generator-434"><a href="#Python.Generator-434"><span class="linenos">434</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Concat</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">func</span><span class="p">(</span> +</span><span id="Python.Generator-435"><a href="#Python.Generator-435"><span class="linenos">435</span></a> <span class="s2">"SAFECONCAT"</span> <span class="k">if</span> <span class="n">e</span><span class="o">.</span><span class="n">args</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="s2">"safe"</span><span class="p">)</span> <span class="k">else</span> <span class="s2">"CONCAT"</span><span class="p">,</span> <span class="o">*</span><span class="n">e</span><span class="o">.</span><span class="n">expressions</span> +</span><span id="Python.Generator-436"><a href="#Python.Generator-436"><span class="linenos">436</span></a> <span class="p">),</span> +</span><span id="Python.Generator-437"><a href="#Python.Generator-437"><span class="linenos">437</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Distinct</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"set(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'this'</span><span class="p">)</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> +</span><span id="Python.Generator-438"><a href="#Python.Generator-438"><span class="linenos">438</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Div</span><span class="p">:</span> <span class="n">_div_sql</span><span class="p">,</span> +</span><span id="Python.Generator-439"><a href="#Python.Generator-439"><span class="linenos">439</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Extract</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"EXTRACT('</span><span class="si">{</span><span class="n">e</span><span class="o">.</span><span class="n">name</span><span class="o">.</span><span class="n">lower</span><span class="p">()</span><span class="si">}</span><span class="s2">', </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'expression'</span><span class="p">)</span><span class="si">}</span><span class="s2">)"</span><span class="p">,</span> +</span><span id="Python.Generator-440"><a href="#Python.Generator-440"><span class="linenos">440</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">In</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="s1">'this'</span><span class="p">)</span><span class="si">}</span><span class="s2"> in </span><span class="se">{{</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">expressions</span><span class="p">(</span><span class="n">e</span><span class="p">,</span><span class="w"> </span><span class="n">flat</span><span class="o">=</span><span class="kc">True</span><span class="p">)</span><span class="si">}</span><span class="se">}}</span><span class="s2">"</span><span class="p">,</span> +</span><span id="Python.Generator-441"><a href="#Python.Generator-441"><span class="linenos">441</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Interval</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"INTERVAL(</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">, '</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">unit</span><span class="p">)</span><span class="si">}</span><span class="s2">')"</span><span class="p">,</span> +</span><span id="Python.Generator-442"><a href="#Python.Generator-442"><span class="linenos">442</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Is</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"=="</span><span class="p">)</span> +</span><span id="Python.Generator-443"><a href="#Python.Generator-443"><span class="linenos">443</span></a> <span class="k">if</span> <span class="nb">isinstance</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">,</span> <span class="n">exp</span><span class="o">.</span><span class="n">Literal</span><span class="p">)</span> +</span><span id="Python.Generator-444"><a href="#Python.Generator-444"><span class="linenos">444</span></a> <span class="k">else</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"is"</span><span class="p">),</span> +</span><span id="Python.Generator-445"><a href="#Python.Generator-445"><span class="linenos">445</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Lambda</span><span class="p">:</span> <span class="n">_lambda_sql</span><span class="p">,</span> +</span><span id="Python.Generator-446"><a href="#Python.Generator-446"><span class="linenos">446</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Not</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="sa">f</span><span class="s2">"not </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="n">e</span><span class="o">.</span><span class="n">this</span><span class="p">)</span><span class="si">}</span><span class="s2">"</span><span class="p">,</span> +</span><span id="Python.Generator-447"><a href="#Python.Generator-447"><span class="linenos">447</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Null</span><span class="p">:</span> <span class="k">lambda</span> <span class="o">*</span><span class="n">_</span><span class="p">:</span> <span class="s2">"None"</span><span class="p">,</span> +</span><span id="Python.Generator-448"><a href="#Python.Generator-448"><span class="linenos">448</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Or</span><span class="p">:</span> <span class="k">lambda</span> <span class="bp">self</span><span class="p">,</span> <span class="n">e</span><span class="p">:</span> <span class="bp">self</span><span class="o">.</span><span class="n">binary</span><span class="p">(</span><span class="n">e</span><span class="p">,</span> <span class="s2">"or"</span><span class="p">),</span> +</span><span id="Python.Generator-449"><a href="#Python.Generator-449"><span class="linenos">449</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Ordered</span><span class="p">:</span> <span class="n">_ordered_py</span><span class="p">,</span> +</span><span id="Python.Generator-450"><a href="#Python.Generator-450"><span class="linenos">450</span></a> <span class="n">exp</span><span class="o">.</span><span class="n">Star</span><span class="p">:</span> <span class="k">lambda</span> <span class="o">*</span><span class="n">_</span><span class="p">:</span> <span class="s2">"1"</span><span class="p">,</span> +</span><span id="Python.Generator-451"><a href="#Python.Generator-451"><span class="linenos">451</span></a> <span class="p">}</span> </span></pre></div> @@ -2064,7 +2074,7 @@ Default: True</li> <div class="attr variable"> <span class="name">TRANSFORMS</span> = <input id="Python.Generator.TRANSFORMS-view-value" class="view-value-toggle-state" type="checkbox" aria-hidden="true" tabindex="-1"> - <label class="view-value-button pdoc-button" for="Python.Generator.TRANSFORMS-view-value"></label><span class="default_value">{<class '<a href="../expressions.html#Add">sqlglot.expressions.Add</a>'>: <function _rename>, <class '<a href="../expressions.html#And">sqlglot.expressions.And</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#ArrayContained">sqlglot.expressions.ArrayContained</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayContains">sqlglot.expressions.ArrayContains</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayOverlaps">sqlglot.expressions.ArrayOverlaps</a>'>: <function _rename>, <class '<a href="../expressions.html#Binary">sqlglot.expressions.Binary</a>'>: <function _rename>, <class '<a href="../expressions.html#BitwiseAnd">sqlglot.expressions.BitwiseAnd</a>'>: <function _rename>, <class '<a href="../expressions.html#BitwiseLeftShift">sqlglot.expressions.BitwiseLeftShift</a>'>: <function _rename>, <class '<a href="../expressions.html#BitwiseOr">sqlglot.expressions.BitwiseOr</a>'>: <function _rename>, <class '<a href="../expressions.html#BitwiseRightShift">sqlglot.expressions.BitwiseRightShift</a>'>: <function _rename>, <class '<a href="../expressions.html#BitwiseXor">sqlglot.expressions.BitwiseXor</a>'>: <function _rename>, <class '<a href="../expressions.html#Collate">sqlglot.expressions.Collate</a>'>: <function _rename>, <class '<a href="../expressions.html#Connector">sqlglot.expressions.Connector</a>'>: <function _rename>, <class '<a href="../expressions.html#DPipe">sqlglot.expressions.DPipe</a>'>: <function _rename>, <class '<a href="../expressions.html#Distance">sqlglot.expressions.Distance</a>'>: <function _rename>, <class '<a href="../expressions.html#Div">sqlglot.expressions.Div</a>'>: <function _div_sql>, <class '<a href="../expressions.html#Dot">sqlglot.expressions.Dot</a>'>: <function _rename>, <class '<a href="../expressions.html#EQ">sqlglot.expressions.EQ</a>'>: <function _rename>, <class '<a href="../expressions.html#Escape">sqlglot.expressions.Escape</a>'>: <function _rename>, <class '<a href="../expressions.html#GT">sqlglot.expressions.GT</a>'>: <function _rename>, <class '<a href="../expressions.html#GTE">sqlglot.expressions.GTE</a>'>: <function _rename>, <class '<a href="../expressions.html#Glob">sqlglot.expressions.Glob</a>'>: <function _rename>, <class '<a href="../expressions.html#ILike">sqlglot.expressions.ILike</a>'>: <function _rename>, <class '<a href="../expressions.html#ILikeAny">sqlglot.expressions.ILikeAny</a>'>: <function _rename>, <class '<a href="../expressions.html#IntDiv">sqlglot.expressions.IntDiv</a>'>: <function _rename>, <class '<a href="../expressions.html#Is">sqlglot.expressions.Is</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#JSONArrayContains">sqlglot.expressions.JSONArrayContains</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONBContains">sqlglot.expressions.JSONBContains</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONBExtract">sqlglot.expressions.JSONBExtract</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONBExtractScalar">sqlglot.expressions.JSONBExtractScalar</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONExtract">sqlglot.expressions.JSONExtract</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONExtractScalar">sqlglot.expressions.JSONExtractScalar</a>'>: <function _rename>, <class '<a href="../expressions.html#Kwarg">sqlglot.expressions.Kwarg</a>'>: <function _rename>, <class '<a href="../expressions.html#LT">sqlglot.expressions.LT</a>'>: <function _rename>, <class '<a href="../expressions.html#LTE">sqlglot.expressions.LTE</a>'>: <function _rename>, <class '<a href="../expressions.html#Like">sqlglot.expressions.Like</a>'>: <function _rename>, <class '<a href="../expressions.html#LikeAny">sqlglot.expressions.LikeAny</a>'>: <function _rename>, <class '<a href="../expressions.html#Mod">sqlglot.expressions.Mod</a>'>: <function _rename>, <class '<a href="../expressions.html#Mul">sqlglot.expressions.Mul</a>'>: <function _rename>, <class '<a href="../expressions.html#NEQ">sqlglot.expressions.NEQ</a>'>: <function _rename>, <class '<a href="../expressions.html#NullSafeEQ">sqlglot.expressions.NullSafeEQ</a>'>: <function _rename>, <class '<a href="../expressions.html#NullSafeNEQ">sqlglot.expressions.NullSafeNEQ</a>'>: <function _rename>, <class '<a href="../expressions.html#Operator">sqlglot.expressions.Operator</a>'>: <function _rename>, <class '<a href="../expressions.html#Or">sqlglot.expressions.Or</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#Overlaps">sqlglot.expressions.Overlaps</a>'>: <function _rename>, <class '<a href="../expressions.html#Pow">sqlglot.expressions.Pow</a>'>: <function _rename>, <class '<a href="../expressions.html#PropertyEQ">sqlglot.expressions.PropertyEQ</a>'>: <function _rename>, <class '<a href="../expressions.html#RegexpILike">sqlglot.expressions.RegexpILike</a>'>: <function _rename>, <class '<a href="../expressions.html#RegexpLike">sqlglot.expressions.RegexpLike</a>'>: <function _rename>, <class '<a href="../expressions.html#SimilarTo">sqlglot.expressions.SimilarTo</a>'>: <function _rename>, <class '<a href="../expressions.html#Slice">sqlglot.expressions.Slice</a>'>: <function _rename>, <class '<a href="../expressions.html#Sub">sqlglot.expressions.Sub</a>'>: <function _rename>, <class '<a href="../expressions.html#Xor">sqlglot.expressions.Xor</a>'>: <function _rename>, <class '<a href="../expressions.html#Abs">sqlglot.expressions.Abs</a>'>: <function _rename>, <class '<a href="../expressions.html#AnyValue">sqlglot.expressions.AnyValue</a>'>: <function _rename>, <class '<a href="../expressions.html#ApproxDistinct">sqlglot.expressions.ApproxDistinct</a>'>: <function _rename>, <class '<a href="../expressions.html#ApproxQuantile">sqlglot.expressions.ApproxQuantile</a>'>: <function _rename>, <class '<a href="../expressions.html#ApproxTopK">sqlglot.expressions.ApproxTopK</a>'>: <function _rename>, <class '<a href="../expressions.html#ArgMax">sqlglot.expressions.ArgMax</a>'>: <function _rename>, <class '<a href="../expressions.html#ArgMin">sqlglot.expressions.ArgMin</a>'>: <function _rename>, <class '<a href="../expressions.html#Array">sqlglot.expressions.Array</a>'>: <function inline_array_sql>, <class '<a href="../expressions.html#ArrayAgg">sqlglot.expressions.ArrayAgg</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayAll">sqlglot.expressions.ArrayAll</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayAny">sqlglot.expressions.ArrayAny</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayConcat">sqlglot.expressions.ArrayConcat</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayFilter">sqlglot.expressions.ArrayFilter</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayJoin">sqlglot.expressions.ArrayJoin</a>'>: <function _rename>, <class '<a href="../expressions.html#ArraySize">sqlglot.expressions.ArraySize</a>'>: <function _rename>, <class '<a href="../expressions.html#ArraySort">sqlglot.expressions.ArraySort</a>'>: <function _rename>, <class '<a href="../expressions.html#ArraySum">sqlglot.expressions.ArraySum</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayUnionAgg">sqlglot.expressions.ArrayUnionAgg</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayUniqueAgg">sqlglot.expressions.ArrayUniqueAgg</a>'>: <function _rename>, <class '<a href="../expressions.html#Avg">sqlglot.expressions.Avg</a>'>: <function _rename>, <class '<a href="../expressions.html#Case">sqlglot.expressions.Case</a>'>: <function _case_sql>, <class '<a href="../expressions.html#Cast">sqlglot.expressions.Cast</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#CastToStrType">sqlglot.expressions.CastToStrType</a>'>: <function _rename>, <class '<a href="../expressions.html#Ceil">sqlglot.expressions.Ceil</a>'>: <function _rename>, <class '<a href="../expressions.html#Chr">sqlglot.expressions.Chr</a>'>: <function _rename>, <class '<a href="../expressions.html#Coalesce">sqlglot.expressions.Coalesce</a>'>: <function _rename>, <class '<a href="../expressions.html#Concat">sqlglot.expressions.Concat</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#ConcatWs">sqlglot.expressions.ConcatWs</a>'>: <function _rename>, <class '<a href="../expressions.html#Count">sqlglot.expressions.Count</a>'>: <function _rename>, <class '<a href="../expressions.html#CountIf">sqlglot.expressions.CountIf</a>'>: <function _rename>, <class '<a href="../expressions.html#CurrentDate">sqlglot.expressions.CurrentDate</a>'>: <function _rename>, <class '<a href="../expressions.html#CurrentDatetime">sqlglot.expressions.CurrentDatetime</a>'>: <function _rename>, <class '<a href="../expressions.html#CurrentTime">sqlglot.expressions.CurrentTime</a>'>: <function _rename>, <class '<a href="../expressions.html#CurrentTimestamp">sqlglot.expressions.CurrentTimestamp</a>'>: <function _rename>, <class '<a href="../expressions.html#CurrentUser">sqlglot.expressions.CurrentUser</a>'>: <function _rename>, <class '<a href="../expressions.html#Date">sqlglot.expressions.Date</a>'>: <function _rename>, <class '<a href="../expressions.html#DateAdd">sqlglot.expressions.DateAdd</a>'>: <function _rename>, <class '<a href="../expressions.html#DateDiff">sqlglot.expressions.DateDiff</a>'>: <function _rename>, <class '<a href="../expressions.html#DateFromParts">sqlglot.expressions.DateFromParts</a>'>: <function _rename>, <class '<a href="../expressions.html#DateStrToDate">sqlglot.expressions.DateStrToDate</a>'>: <function _rename>, <class '<a href="../expressions.html#DateSub">sqlglot.expressions.DateSub</a>'>: <function _rename>, <class '<a href="../expressions.html#DateToDateStr">sqlglot.expressions.DateToDateStr</a>'>: <function _rename>, <class '<a href="../expressions.html#DateToDi">sqlglot.expressions.DateToDi</a>'>: <function _rename>, <class '<a href="../expressions.html#DateTrunc">sqlglot.expressions.DateTrunc</a>'>: <function _rename>, <class '<a href="../expressions.html#DatetimeAdd">sqlglot.expressions.DatetimeAdd</a>'>: <function _rename>, <class '<a href="../expressions.html#DatetimeDiff">sqlglot.expressions.DatetimeDiff</a>'>: <function _rename>, <class '<a href="../expressions.html#DatetimeSub">sqlglot.expressions.DatetimeSub</a>'>: <function _rename>, <class '<a href="../expressions.html#DatetimeTrunc">sqlglot.expressions.DatetimeTrunc</a>'>: <function _rename>, <class '<a href="../expressions.html#Day">sqlglot.expressions.Day</a>'>: <function _rename>, <class '<a href="../expressions.html#DayOfMonth">sqlglot.expressions.DayOfMonth</a>'>: <function _rename>, <class '<a href="../expressions.html#DayOfWeek">sqlglot.expressions.DayOfWeek</a>'>: <function _rename>, <class '<a href="../expressions.html#DayOfYear">sqlglot.expressions.DayOfYear</a>'>: <function _rename>, <class '<a href="../expressions.html#Decode">sqlglot.expressions.Decode</a>'>: <function _rename>, <class '<a href="../expressions.html#DiToDate">sqlglot.expressions.DiToDate</a>'>: <function _rename>, <class '<a href="../expressions.html#Encode">sqlglot.expressions.Encode</a>'>: <function _rename>, <class '<a href="../expressions.html#Exp">sqlglot.expressions.Exp</a>'>: <function _rename>, <class '<a href="../expressions.html#Explode">sqlglot.expressions.Explode</a>'>: <function _rename>, <class '<a href="../expressions.html#ExplodeOuter">sqlglot.expressions.ExplodeOuter</a>'>: <function _rename>, <class '<a href="../expressions.html#Extract">sqlglot.expressions.Extract</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#First">sqlglot.expressions.First</a>'>: <function _rename>, <class '<a href="../expressions.html#Flatten">sqlglot.expressions.Flatten</a>'>: <function _rename>, <class '<a href="../expressions.html#Floor">sqlglot.expressions.Floor</a>'>: <function _rename>, <class '<a href="../expressions.html#FromBase">sqlglot.expressions.FromBase</a>'>: <function _rename>, <class '<a href="../expressions.html#FromBase64">sqlglot.expressions.FromBase64</a>'>: <function _rename>, <class '<a href="../expressions.html#GenerateSeries">sqlglot.expressions.GenerateSeries</a>'>: <function _rename>, <class '<a href="../expressions.html#Greatest">sqlglot.expressions.Greatest</a>'>: <function _rename>, <class '<a href="../expressions.html#GroupConcat">sqlglot.expressions.GroupConcat</a>'>: <function _rename>, <class '<a href="../expressions.html#Hex">sqlglot.expressions.Hex</a>'>: <function _rename>, <class '<a href="../expressions.html#Hll">sqlglot.expressions.Hll</a>'>: <function _rename>, <class '<a href="../expressions.html#If">sqlglot.expressions.If</a>'>: <function _rename>, <class '<a href="../expressions.html#Initcap">sqlglot.expressions.Initcap</a>'>: <function _rename>, <class '<a href="../expressions.html#IsInf">sqlglot.expressions.IsInf</a>'>: <function _rename>, <class '<a href="../expressions.html#IsNan">sqlglot.expressions.IsNan</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONArray">sqlglot.expressions.JSONArray</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONArrayAgg">sqlglot.expressions.JSONArrayAgg</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONFormat">sqlglot.expressions.JSONFormat</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONObject">sqlglot.expressions.JSONObject</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONTable">sqlglot.expressions.JSONTable</a>'>: <function _rename>, <class '<a href="../expressions.html#Last">sqlglot.expressions.Last</a>'>: <function _rename>, <class '<a href="../expressions.html#LastDateOfMonth">sqlglot.expressions.LastDateOfMonth</a>'>: <function _rename>, <class '<a href="../expressions.html#Least">sqlglot.expressions.Least</a>'>: <function _rename>, <class '<a href="../expressions.html#Left">sqlglot.expressions.Left</a>'>: <function _rename>, <class '<a href="../expressions.html#Length">sqlglot.expressions.Length</a>'>: <function _rename>, <class '<a href="../expressions.html#Levenshtein">sqlglot.expressions.Levenshtein</a>'>: <function _rename>, <class '<a href="../expressions.html#Ln">sqlglot.expressions.Ln</a>'>: <function _rename>, <class '<a href="../expressions.html#Log">sqlglot.expressions.Log</a>'>: <function _rename>, <class '<a href="../expressions.html#Log10">sqlglot.expressions.Log10</a>'>: <function _rename>, <class '<a href="../expressions.html#Log2">sqlglot.expressions.Log2</a>'>: <function _rename>, <class '<a href="../expressions.html#LogicalAnd">sqlglot.expressions.LogicalAnd</a>'>: <function _rename>, <class '<a href="../expressions.html#LogicalOr">sqlglot.expressions.LogicalOr</a>'>: <function _rename>, <class '<a href="../expressions.html#Lower">sqlglot.expressions.Lower</a>'>: <function _rename>, <class '<a href="../expressions.html#MD5">sqlglot.expressions.MD5</a>'>: <function _rename>, <class '<a href="../expressions.html#MD5Digest">sqlglot.expressions.MD5Digest</a>'>: <function _rename>, <class '<a href="../expressions.html#Map">sqlglot.expressions.Map</a>'>: <function _rename>, <class '<a href="../expressions.html#MapFromEntries">sqlglot.expressions.MapFromEntries</a>'>: <function _rename>, <class '<a href="../expressions.html#MatchAgainst">sqlglot.expressions.MatchAgainst</a>'>: <function _rename>, <class '<a href="../expressions.html#Max">sqlglot.expressions.Max</a>'>: <function _rename>, <class '<a href="../expressions.html#Min">sqlglot.expressions.Min</a>'>: <function _rename>, <class '<a href="../expressions.html#Month">sqlglot.expressions.Month</a>'>: <function _rename>, <class '<a href="../expressions.html#MonthsBetween">sqlglot.expressions.MonthsBetween</a>'>: <function _rename>, <class '<a href="../expressions.html#NextValueFor">sqlglot.expressions.NextValueFor</a>'>: <function _rename>, <class '<a href="../expressions.html#Nullif">sqlglot.expressions.Nullif</a>'>: <function _rename>, <class '<a href="../expressions.html#NumberToStr">sqlglot.expressions.NumberToStr</a>'>: <function _rename>, <class '<a href="../expressions.html#Nvl2">sqlglot.expressions.Nvl2</a>'>: <function _rename>, <class '<a href="../expressions.html#OpenJSON">sqlglot.expressions.OpenJSON</a>'>: <function _rename>, <class '<a href="../expressions.html#ParameterizedAgg">sqlglot.expressions.ParameterizedAgg</a>'>: <function _rename>, <class '<a href="../expressions.html#ParseJSON">sqlglot.expressions.ParseJSON</a>'>: <function _rename>, <class '<a href="../expressions.html#PercentileCont">sqlglot.expressions.PercentileCont</a>'>: <function _rename>, <class '<a href="../expressions.html#PercentileDisc">sqlglot.expressions.PercentileDisc</a>'>: <function _rename>, <class '<a href="../expressions.html#Posexplode">sqlglot.expressions.Posexplode</a>'>: <function _rename>, <class '<a href="../expressions.html#PosexplodeOuter">sqlglot.expressions.PosexplodeOuter</a>'>: <function _rename>, <class '<a href="../expressions.html#Predict">sqlglot.expressions.Predict</a>'>: <function _rename>, <class '<a href="../expressions.html#Quantile">sqlglot.expressions.Quantile</a>'>: <function _rename>, <class '<a href="../expressions.html#RangeN">sqlglot.expressions.RangeN</a>'>: <function _rename>, <class '<a href="../expressions.html#ReadCSV">sqlglot.expressions.ReadCSV</a>'>: <function _rename>, <class '<a href="../expressions.html#Reduce">sqlglot.expressions.Reduce</a>'>: <function _rename>, <class '<a href="../expressions.html#RegexpExtract">sqlglot.expressions.RegexpExtract</a>'>: <function _rename>, <class '<a href="../expressions.html#RegexpReplace">sqlglot.expressions.RegexpReplace</a>'>: <function _rename>, <class '<a href="../expressions.html#RegexpSplit">sqlglot.expressions.RegexpSplit</a>'>: <function _rename>, <class '<a href="../expressions.html#Repeat">sqlglot.expressions.Repeat</a>'>: <function _rename>, <class '<a href="../expressions.html#Right">sqlglot.expressions.Right</a>'>: <function _rename>, <class '<a href="../expressions.html#Round">sqlglot.expressions.Round</a>'>: <function _rename>, <class '<a href="../expressions.html#RowNumber">sqlglot.expressions.RowNumber</a>'>: <function _rename>, <class '<a href="../expressions.html#SHA">sqlglot.expressions.SHA</a>'>: <function _rename>, <class '<a href="../expressions.html#SHA2">sqlglot.expressions.SHA2</a>'>: <function _rename>, <class '<a href="../expressions.html#SafeDivide">sqlglot.expressions.SafeDivide</a>'>: <function _rename>, <class '<a href="../expressions.html#SortArray">sqlglot.expressions.SortArray</a>'>: <function _rename>, <class '<a href="../expressions.html#Split">sqlglot.expressions.Split</a>'>: <function _rename>, <class '<a href="../expressions.html#Sqrt">sqlglot.expressions.Sqrt</a>'>: <function _rename>, <class '<a href="../expressions.html#StandardHash">sqlglot.expressions.StandardHash</a>'>: <function _rename>, <class '<a href="../expressions.html#StarMap">sqlglot.expressions.StarMap</a>'>: <function _rename>, <class '<a href="../expressions.html#StartsWith">sqlglot.expressions.StartsWith</a>'>: <function _rename>, <class '<a href="../expressions.html#Stddev">sqlglot.expressions.Stddev</a>'>: <function _rename>, <class '<a href="../expressions.html#StddevPop">sqlglot.expressions.StddevPop</a>'>: <function _rename>, <class '<a href="../expressions.html#StddevSamp">sqlglot.expressions.StddevSamp</a>'>: <function _rename>, <class '<a href="../expressions.html#StrPosition">sqlglot.expressions.StrPosition</a>'>: <function _rename>, <class '<a href="../expressions.html#StrToDate">sqlglot.expressions.StrToDate</a>'>: <function _rename>, <class '<a href="../expressions.html#StrToMap">sqlglot.expressions.StrToMap</a>'>: <function _rename>, <class '<a href="../expressions.html#StrToTime">sqlglot.expressions.StrToTime</a>'>: <function _rename>, <class '<a href="../expressions.html#StrToUnix">sqlglot.expressions.StrToUnix</a>'>: <function _rename>, <class '<a href="../expressions.html#Struct">sqlglot.expressions.Struct</a>'>: <function _rename>, <class '<a href="../expressions.html#StructExtract">sqlglot.expressions.StructExtract</a>'>: <function _rename>, <class '<a href="../expressions.html#Stuff">sqlglot.expressions.Stuff</a>'>: <function _rename>, <class '<a href="../expressions.html#Substring">sqlglot.expressions.Substring</a>'>: <function _rename>, <class '<a href="../expressions.html#Sum">sqlglot.expressions.Sum</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeAdd">sqlglot.expressions.TimeAdd</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeDiff">sqlglot.expressions.TimeDiff</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeStrToDate">sqlglot.expressions.TimeStrToDate</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeStrToTime">sqlglot.expressions.TimeStrToTime</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeStrToUnix">sqlglot.expressions.TimeStrToUnix</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeSub">sqlglot.expressions.TimeSub</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeToStr">sqlglot.expressions.TimeToStr</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeToTimeStr">sqlglot.expressions.TimeToTimeStr</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeToUnix">sqlglot.expressions.TimeToUnix</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeTrunc">sqlglot.expressions.TimeTrunc</a>'>: <function _rename>, <class '<a href="../expressions.html#Timestamp">sqlglot.expressions.Timestamp</a>'>: <function _rename>, <class '<a href="../expressions.html#TimestampAdd">sqlglot.expressions.TimestampAdd</a>'>: <function _rename>, <class '<a href="../expressions.html#TimestampDiff">sqlglot.expressions.TimestampDiff</a>'>: <function _rename>, <class '<a href="../expressions.html#TimestampSub">sqlglot.expressions.TimestampSub</a>'>: <function _rename>, <class '<a href="../expressions.html#TimestampTrunc">sqlglot.expressions.TimestampTrunc</a>'>: <function _rename>, <class '<a href="../expressions.html#ToBase64">sqlglot.expressions.ToBase64</a>'>: <function _rename>, <class '<a href="../expressions.html#ToChar">sqlglot.expressions.ToChar</a>'>: <function _rename>, <class '<a href="../expressions.html#ToDays">sqlglot.expressions.ToDays</a>'>: <function _rename>, <class '<a href="../expressions.html#Transform">sqlglot.expressions.Transform</a>'>: <function _rename>, <class '<a href="../expressions.html#Trim">sqlglot.expressions.Trim</a>'>: <function _rename>, <class '<a href="../expressions.html#TryCast">sqlglot.expressions.TryCast</a>'>: <function _rename>, <class '<a href="../expressions.html#TsOrDiToDi">sqlglot.expressions.TsOrDiToDi</a>'>: <function _rename>, <class '<a href="../expressions.html#TsOrDsAdd">sqlglot.expressions.TsOrDsAdd</a>'>: <function _rename>, <class '<a href="../expressions.html#TsOrDsDiff">sqlglot.expressions.TsOrDsDiff</a>'>: <function _rename>, <class '<a href="../expressions.html#TsOrDsToDate">sqlglot.expressions.TsOrDsToDate</a>'>: <function _rename>, <class '<a href="../expressions.html#TsOrDsToDateStr">sqlglot.expressions.TsOrDsToDateStr</a>'>: <function _rename>, <class '<a href="../expressions.html#Unhex">sqlglot.expressions.Unhex</a>'>: <function _rename>, <class '<a href="../expressions.html#UnixToStr">sqlglot.expressions.UnixToStr</a>'>: <function _rename>, <class '<a href="../expressions.html#UnixToTime">sqlglot.expressions.UnixToTime</a>'>: <function _rename>, <class '<a href="../expressions.html#UnixToTimeStr">sqlglot.expressions.UnixToTimeStr</a>'>: <function _rename>, <class '<a href="../expressions.html#Upper">sqlglot.expressions.Upper</a>'>: <function _rename>, <class '<a href="../expressions.html#VarMap">sqlglot.expressions.VarMap</a>'>: <function _rename>, <class '<a href="../expressions.html#Variance">sqlglot.expressions.Variance</a>'>: <function _rename>, <class '<a href="../expressions.html#VariancePop">sqlglot.expressions.VariancePop</a>'>: <function _rename>, <class '<a href="../expressions.html#Week">sqlglot.expressions.Week</a>'>: <function _rename>, <class '<a href="../expressions.html#WeekOfYear">sqlglot.expressions.WeekOfYear</a>'>: <function _rename>, <class '<a href="../expressions.html#When">sqlglot.expressions.When</a>'>: <function _rename>, <class '<a href="../expressions.html#XMLTable">sqlglot.expressions.XMLTable</a>'>: <function _rename>, <class '<a href="../expressions.html#Year">sqlglot.expressions.Year</a>'>: <function _rename>, <class '<a href="../expressions.html#Alias">sqlglot.expressions.Alias</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#Between">sqlglot.expressions.Between</a>'>: <function _rename>, <class '<a href="../expressions.html#Boolean">sqlglot.expressions.Boolean</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#Column">sqlglot.expressions.Column</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#Distinct">sqlglot.expressions.Distinct</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#In">sqlglot.expressions.In</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#Interval">sqlglot.expressions.Interval</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#Lambda">sqlglot.expressions.Lambda</a>'>: <function _lambda_sql>, <class '<a href="../expressions.html#Not">sqlglot.expressions.Not</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#Null">sqlglot.expressions.Null</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#Ordered">sqlglot.expressions.Ordered</a>'>: <function _ordered_py>, <class '<a href="../expressions.html#Star">sqlglot.expressions.Star</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>}</span> + <label class="view-value-button pdoc-button" for="Python.Generator.TRANSFORMS-view-value"></label><span class="default_value">{<class '<a href="../expressions.html#Add">sqlglot.expressions.Add</a>'>: <function _rename>, <class '<a href="../expressions.html#And">sqlglot.expressions.And</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#ArrayContained">sqlglot.expressions.ArrayContained</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayContains">sqlglot.expressions.ArrayContains</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayOverlaps">sqlglot.expressions.ArrayOverlaps</a>'>: <function _rename>, <class '<a href="../expressions.html#Binary">sqlglot.expressions.Binary</a>'>: <function _rename>, <class '<a href="../expressions.html#BitwiseAnd">sqlglot.expressions.BitwiseAnd</a>'>: <function _rename>, <class '<a href="../expressions.html#BitwiseLeftShift">sqlglot.expressions.BitwiseLeftShift</a>'>: <function _rename>, <class '<a href="../expressions.html#BitwiseOr">sqlglot.expressions.BitwiseOr</a>'>: <function _rename>, <class '<a href="../expressions.html#BitwiseRightShift">sqlglot.expressions.BitwiseRightShift</a>'>: <function _rename>, <class '<a href="../expressions.html#BitwiseXor">sqlglot.expressions.BitwiseXor</a>'>: <function _rename>, <class '<a href="../expressions.html#Collate">sqlglot.expressions.Collate</a>'>: <function _rename>, <class '<a href="../expressions.html#Connector">sqlglot.expressions.Connector</a>'>: <function _rename>, <class '<a href="../expressions.html#DPipe">sqlglot.expressions.DPipe</a>'>: <function _rename>, <class '<a href="../expressions.html#Distance">sqlglot.expressions.Distance</a>'>: <function _rename>, <class '<a href="../expressions.html#Div">sqlglot.expressions.Div</a>'>: <function _div_sql>, <class '<a href="../expressions.html#Dot">sqlglot.expressions.Dot</a>'>: <function _rename>, <class '<a href="../expressions.html#EQ">sqlglot.expressions.EQ</a>'>: <function _rename>, <class '<a href="../expressions.html#Escape">sqlglot.expressions.Escape</a>'>: <function _rename>, <class '<a href="../expressions.html#GT">sqlglot.expressions.GT</a>'>: <function _rename>, <class '<a href="../expressions.html#GTE">sqlglot.expressions.GTE</a>'>: <function _rename>, <class '<a href="../expressions.html#Glob">sqlglot.expressions.Glob</a>'>: <function _rename>, <class '<a href="../expressions.html#ILike">sqlglot.expressions.ILike</a>'>: <function _rename>, <class '<a href="../expressions.html#ILikeAny">sqlglot.expressions.ILikeAny</a>'>: <function _rename>, <class '<a href="../expressions.html#IntDiv">sqlglot.expressions.IntDiv</a>'>: <function _rename>, <class '<a href="../expressions.html#Is">sqlglot.expressions.Is</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#JSONArrayContains">sqlglot.expressions.JSONArrayContains</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONBContains">sqlglot.expressions.JSONBContains</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONBExtract">sqlglot.expressions.JSONBExtract</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONBExtractScalar">sqlglot.expressions.JSONBExtractScalar</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONExtract">sqlglot.expressions.JSONExtract</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONExtractScalar">sqlglot.expressions.JSONExtractScalar</a>'>: <function _rename>, <class '<a href="../expressions.html#Kwarg">sqlglot.expressions.Kwarg</a>'>: <function _rename>, <class '<a href="../expressions.html#LT">sqlglot.expressions.LT</a>'>: <function _rename>, <class '<a href="../expressions.html#LTE">sqlglot.expressions.LTE</a>'>: <function _rename>, <class '<a href="../expressions.html#Like">sqlglot.expressions.Like</a>'>: <function _rename>, <class '<a href="../expressions.html#LikeAny">sqlglot.expressions.LikeAny</a>'>: <function _rename>, <class '<a href="../expressions.html#Mod">sqlglot.expressions.Mod</a>'>: <function _rename>, <class '<a href="../expressions.html#Mul">sqlglot.expressions.Mul</a>'>: <function _rename>, <class '<a href="../expressions.html#NEQ">sqlglot.expressions.NEQ</a>'>: <function _rename>, <class '<a href="../expressions.html#NullSafeEQ">sqlglot.expressions.NullSafeEQ</a>'>: <function _rename>, <class '<a href="../expressions.html#NullSafeNEQ">sqlglot.expressions.NullSafeNEQ</a>'>: <function _rename>, <class '<a href="../expressions.html#Operator">sqlglot.expressions.Operator</a>'>: <function _rename>, <class '<a href="../expressions.html#Or">sqlglot.expressions.Or</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#Overlaps">sqlglot.expressions.Overlaps</a>'>: <function _rename>, <class '<a href="../expressions.html#Pow">sqlglot.expressions.Pow</a>'>: <function _rename>, <class '<a href="../expressions.html#PropertyEQ">sqlglot.expressions.PropertyEQ</a>'>: <function _rename>, <class '<a href="../expressions.html#RegexpILike">sqlglot.expressions.RegexpILike</a>'>: <function _rename>, <class '<a href="../expressions.html#RegexpLike">sqlglot.expressions.RegexpLike</a>'>: <function _rename>, <class '<a href="../expressions.html#SimilarTo">sqlglot.expressions.SimilarTo</a>'>: <function _rename>, <class '<a href="../expressions.html#Slice">sqlglot.expressions.Slice</a>'>: <function _rename>, <class '<a href="../expressions.html#Sub">sqlglot.expressions.Sub</a>'>: <function _rename>, <class '<a href="../expressions.html#Xor">sqlglot.expressions.Xor</a>'>: <function _rename>, <class '<a href="../expressions.html#Abs">sqlglot.expressions.Abs</a>'>: <function _rename>, <class '<a href="../expressions.html#AnyValue">sqlglot.expressions.AnyValue</a>'>: <function _rename>, <class '<a href="../expressions.html#ApproxDistinct">sqlglot.expressions.ApproxDistinct</a>'>: <function _rename>, <class '<a href="../expressions.html#ApproxQuantile">sqlglot.expressions.ApproxQuantile</a>'>: <function _rename>, <class '<a href="../expressions.html#ApproxTopK">sqlglot.expressions.ApproxTopK</a>'>: <function _rename>, <class '<a href="../expressions.html#ArgMax">sqlglot.expressions.ArgMax</a>'>: <function _rename>, <class '<a href="../expressions.html#ArgMin">sqlglot.expressions.ArgMin</a>'>: <function _rename>, <class '<a href="../expressions.html#Array">sqlglot.expressions.Array</a>'>: <function inline_array_sql>, <class '<a href="../expressions.html#ArrayAgg">sqlglot.expressions.ArrayAgg</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayAll">sqlglot.expressions.ArrayAll</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayAny">sqlglot.expressions.ArrayAny</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayConcat">sqlglot.expressions.ArrayConcat</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayFilter">sqlglot.expressions.ArrayFilter</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayJoin">sqlglot.expressions.ArrayJoin</a>'>: <function _rename>, <class '<a href="../expressions.html#ArraySize">sqlglot.expressions.ArraySize</a>'>: <function _rename>, <class '<a href="../expressions.html#ArraySort">sqlglot.expressions.ArraySort</a>'>: <function _rename>, <class '<a href="../expressions.html#ArraySum">sqlglot.expressions.ArraySum</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayUnionAgg">sqlglot.expressions.ArrayUnionAgg</a>'>: <function _rename>, <class '<a href="../expressions.html#ArrayUniqueAgg">sqlglot.expressions.ArrayUniqueAgg</a>'>: <function _rename>, <class '<a href="../expressions.html#Avg">sqlglot.expressions.Avg</a>'>: <function _rename>, <class '<a href="../expressions.html#Case">sqlglot.expressions.Case</a>'>: <function _case_sql>, <class '<a href="../expressions.html#Cast">sqlglot.expressions.Cast</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#CastToStrType">sqlglot.expressions.CastToStrType</a>'>: <function _rename>, <class '<a href="../expressions.html#Ceil">sqlglot.expressions.Ceil</a>'>: <function _rename>, <class '<a href="../expressions.html#Chr">sqlglot.expressions.Chr</a>'>: <function _rename>, <class '<a href="../expressions.html#Coalesce">sqlglot.expressions.Coalesce</a>'>: <function _rename>, <class '<a href="../expressions.html#Concat">sqlglot.expressions.Concat</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#ConcatWs">sqlglot.expressions.ConcatWs</a>'>: <function _rename>, <class '<a href="../expressions.html#Count">sqlglot.expressions.Count</a>'>: <function _rename>, <class '<a href="../expressions.html#CountIf">sqlglot.expressions.CountIf</a>'>: <function _rename>, <class '<a href="../expressions.html#CurrentDate">sqlglot.expressions.CurrentDate</a>'>: <function _rename>, <class '<a href="../expressions.html#CurrentDatetime">sqlglot.expressions.CurrentDatetime</a>'>: <function _rename>, <class '<a href="../expressions.html#CurrentTime">sqlglot.expressions.CurrentTime</a>'>: <function _rename>, <class '<a href="../expressions.html#CurrentTimestamp">sqlglot.expressions.CurrentTimestamp</a>'>: <function _rename>, <class '<a href="../expressions.html#CurrentUser">sqlglot.expressions.CurrentUser</a>'>: <function _rename>, <class '<a href="../expressions.html#Date">sqlglot.expressions.Date</a>'>: <function _rename>, <class '<a href="../expressions.html#DateAdd">sqlglot.expressions.DateAdd</a>'>: <function _rename>, <class '<a href="../expressions.html#DateDiff">sqlglot.expressions.DateDiff</a>'>: <function _rename>, <class '<a href="../expressions.html#DateFromParts">sqlglot.expressions.DateFromParts</a>'>: <function _rename>, <class '<a href="../expressions.html#DateStrToDate">sqlglot.expressions.DateStrToDate</a>'>: <function _rename>, <class '<a href="../expressions.html#DateSub">sqlglot.expressions.DateSub</a>'>: <function _rename>, <class '<a href="../expressions.html#DateToDateStr">sqlglot.expressions.DateToDateStr</a>'>: <function _rename>, <class '<a href="../expressions.html#DateToDi">sqlglot.expressions.DateToDi</a>'>: <function _rename>, <class '<a href="../expressions.html#DateTrunc">sqlglot.expressions.DateTrunc</a>'>: <function _rename>, <class '<a href="../expressions.html#DatetimeAdd">sqlglot.expressions.DatetimeAdd</a>'>: <function _rename>, <class '<a href="../expressions.html#DatetimeDiff">sqlglot.expressions.DatetimeDiff</a>'>: <function _rename>, <class '<a href="../expressions.html#DatetimeSub">sqlglot.expressions.DatetimeSub</a>'>: <function _rename>, <class '<a href="../expressions.html#DatetimeTrunc">sqlglot.expressions.DatetimeTrunc</a>'>: <function _rename>, <class '<a href="../expressions.html#Day">sqlglot.expressions.Day</a>'>: <function _rename>, <class '<a href="../expressions.html#DayOfMonth">sqlglot.expressions.DayOfMonth</a>'>: <function _rename>, <class '<a href="../expressions.html#DayOfWeek">sqlglot.expressions.DayOfWeek</a>'>: <function _rename>, <class '<a href="../expressions.html#DayOfYear">sqlglot.expressions.DayOfYear</a>'>: <function _rename>, <class '<a href="../expressions.html#Decode">sqlglot.expressions.Decode</a>'>: <function _rename>, <class '<a href="../expressions.html#DiToDate">sqlglot.expressions.DiToDate</a>'>: <function _rename>, <class '<a href="../expressions.html#Encode">sqlglot.expressions.Encode</a>'>: <function _rename>, <class '<a href="../expressions.html#Exp">sqlglot.expressions.Exp</a>'>: <function _rename>, <class '<a href="../expressions.html#Explode">sqlglot.expressions.Explode</a>'>: <function _rename>, <class '<a href="../expressions.html#ExplodeOuter">sqlglot.expressions.ExplodeOuter</a>'>: <function _rename>, <class '<a href="../expressions.html#Extract">sqlglot.expressions.Extract</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#First">sqlglot.expressions.First</a>'>: <function _rename>, <class '<a href="../expressions.html#Flatten">sqlglot.expressions.Flatten</a>'>: <function _rename>, <class '<a href="../expressions.html#Floor">sqlglot.expressions.Floor</a>'>: <function _rename>, <class '<a href="../expressions.html#FromBase">sqlglot.expressions.FromBase</a>'>: <function _rename>, <class '<a href="../expressions.html#FromBase64">sqlglot.expressions.FromBase64</a>'>: <function _rename>, <class '<a href="../expressions.html#GenerateSeries">sqlglot.expressions.GenerateSeries</a>'>: <function _rename>, <class '<a href="../expressions.html#Greatest">sqlglot.expressions.Greatest</a>'>: <function _rename>, <class '<a href="../expressions.html#GroupConcat">sqlglot.expressions.GroupConcat</a>'>: <function _rename>, <class '<a href="../expressions.html#Hex">sqlglot.expressions.Hex</a>'>: <function _rename>, <class '<a href="../expressions.html#Hll">sqlglot.expressions.Hll</a>'>: <function _rename>, <class '<a href="../expressions.html#If">sqlglot.expressions.If</a>'>: <function _rename>, <class '<a href="../expressions.html#Initcap">sqlglot.expressions.Initcap</a>'>: <function _rename>, <class '<a href="../expressions.html#IsInf">sqlglot.expressions.IsInf</a>'>: <function _rename>, <class '<a href="../expressions.html#IsNan">sqlglot.expressions.IsNan</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONArray">sqlglot.expressions.JSONArray</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONArrayAgg">sqlglot.expressions.JSONArrayAgg</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONFormat">sqlglot.expressions.JSONFormat</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONObject">sqlglot.expressions.JSONObject</a>'>: <function _rename>, <class '<a href="../expressions.html#JSONTable">sqlglot.expressions.JSONTable</a>'>: <function _rename>, <class '<a href="../expressions.html#Last">sqlglot.expressions.Last</a>'>: <function _rename>, <class '<a href="../expressions.html#LastDateOfMonth">sqlglot.expressions.LastDateOfMonth</a>'>: <function _rename>, <class '<a href="../expressions.html#Least">sqlglot.expressions.Least</a>'>: <function _rename>, <class '<a href="../expressions.html#Left">sqlglot.expressions.Left</a>'>: <function _rename>, <class '<a href="../expressions.html#Length">sqlglot.expressions.Length</a>'>: <function _rename>, <class '<a href="../expressions.html#Levenshtein">sqlglot.expressions.Levenshtein</a>'>: <function _rename>, <class '<a href="../expressions.html#Ln">sqlglot.expressions.Ln</a>'>: <function _rename>, <class '<a href="../expressions.html#Log">sqlglot.expressions.Log</a>'>: <function _rename>, <class '<a href="../expressions.html#Log10">sqlglot.expressions.Log10</a>'>: <function _rename>, <class '<a href="../expressions.html#Log2">sqlglot.expressions.Log2</a>'>: <function _rename>, <class '<a href="../expressions.html#LogicalAnd">sqlglot.expressions.LogicalAnd</a>'>: <function _rename>, <class '<a href="../expressions.html#LogicalOr">sqlglot.expressions.LogicalOr</a>'>: <function _rename>, <class '<a href="../expressions.html#Lower">sqlglot.expressions.Lower</a>'>: <function _rename>, <class '<a href="../expressions.html#MD5">sqlglot.expressions.MD5</a>'>: <function _rename>, <class '<a href="../expressions.html#MD5Digest">sqlglot.expressions.MD5Digest</a>'>: <function _rename>, <class '<a href="../expressions.html#Map">sqlglot.expressions.Map</a>'>: <function _rename>, <class '<a href="../expressions.html#MapFromEntries">sqlglot.expressions.MapFromEntries</a>'>: <function _rename>, <class '<a href="../expressions.html#MatchAgainst">sqlglot.expressions.MatchAgainst</a>'>: <function _rename>, <class '<a href="../expressions.html#Max">sqlglot.expressions.Max</a>'>: <function _rename>, <class '<a href="../expressions.html#Min">sqlglot.expressions.Min</a>'>: <function _rename>, <class '<a href="../expressions.html#Month">sqlglot.expressions.Month</a>'>: <function _rename>, <class '<a href="../expressions.html#MonthsBetween">sqlglot.expressions.MonthsBetween</a>'>: <function _rename>, <class '<a href="../expressions.html#NextValueFor">sqlglot.expressions.NextValueFor</a>'>: <function _rename>, <class '<a href="../expressions.html#Nullif">sqlglot.expressions.Nullif</a>'>: <function _rename>, <class '<a href="../expressions.html#NumberToStr">sqlglot.expressions.NumberToStr</a>'>: <function _rename>, <class '<a href="../expressions.html#Nvl2">sqlglot.expressions.Nvl2</a>'>: <function _rename>, <class '<a href="../expressions.html#OpenJSON">sqlglot.expressions.OpenJSON</a>'>: <function _rename>, <class '<a href="../expressions.html#ParameterizedAgg">sqlglot.expressions.ParameterizedAgg</a>'>: <function _rename>, <class '<a href="../expressions.html#ParseJSON">sqlglot.expressions.ParseJSON</a>'>: <function _rename>, <class '<a href="../expressions.html#PercentileCont">sqlglot.expressions.PercentileCont</a>'>: <function _rename>, <class '<a href="../expressions.html#PercentileDisc">sqlglot.expressions.PercentileDisc</a>'>: <function _rename>, <class '<a href="../expressions.html#Posexplode">sqlglot.expressions.Posexplode</a>'>: <function _rename>, <class '<a href="../expressions.html#PosexplodeOuter">sqlglot.expressions.PosexplodeOuter</a>'>: <function _rename>, <class '<a href="../expressions.html#Predict">sqlglot.expressions.Predict</a>'>: <function _rename>, <class '<a href="../expressions.html#Quantile">sqlglot.expressions.Quantile</a>'>: <function _rename>, <class '<a href="../expressions.html#RangeN">sqlglot.expressions.RangeN</a>'>: <function _rename>, <class '<a href="../expressions.html#ReadCSV">sqlglot.expressions.ReadCSV</a>'>: <function _rename>, <class '<a href="../expressions.html#Reduce">sqlglot.expressions.Reduce</a>'>: <function _rename>, <class '<a href="../expressions.html#RegexpExtract">sqlglot.expressions.RegexpExtract</a>'>: <function _rename>, <class '<a href="../expressions.html#RegexpReplace">sqlglot.expressions.RegexpReplace</a>'>: <function _rename>, <class '<a href="../expressions.html#RegexpSplit">sqlglot.expressions.RegexpSplit</a>'>: <function _rename>, <class '<a href="../expressions.html#Repeat">sqlglot.expressions.Repeat</a>'>: <function _rename>, <class '<a href="../expressions.html#Right">sqlglot.expressions.Right</a>'>: <function _rename>, <class '<a href="../expressions.html#Round">sqlglot.expressions.Round</a>'>: <function _rename>, <class '<a href="../expressions.html#RowNumber">sqlglot.expressions.RowNumber</a>'>: <function _rename>, <class '<a href="../expressions.html#SHA">sqlglot.expressions.SHA</a>'>: <function _rename>, <class '<a href="../expressions.html#SHA2">sqlglot.expressions.SHA2</a>'>: <function _rename>, <class '<a href="../expressions.html#SafeDivide">sqlglot.expressions.SafeDivide</a>'>: <function _rename>, <class '<a href="../expressions.html#SortArray">sqlglot.expressions.SortArray</a>'>: <function _rename>, <class '<a href="../expressions.html#Split">sqlglot.expressions.Split</a>'>: <function _rename>, <class '<a href="../expressions.html#Sqrt">sqlglot.expressions.Sqrt</a>'>: <function _rename>, <class '<a href="../expressions.html#StandardHash">sqlglot.expressions.StandardHash</a>'>: <function _rename>, <class '<a href="../expressions.html#StarMap">sqlglot.expressions.StarMap</a>'>: <function _rename>, <class '<a href="../expressions.html#StartsWith">sqlglot.expressions.StartsWith</a>'>: <function _rename>, <class '<a href="../expressions.html#Stddev">sqlglot.expressions.Stddev</a>'>: <function _rename>, <class '<a href="../expressions.html#StddevPop">sqlglot.expressions.StddevPop</a>'>: <function _rename>, <class '<a href="../expressions.html#StddevSamp">sqlglot.expressions.StddevSamp</a>'>: <function _rename>, <class '<a href="../expressions.html#StrPosition">sqlglot.expressions.StrPosition</a>'>: <function _rename>, <class '<a href="../expressions.html#StrToDate">sqlglot.expressions.StrToDate</a>'>: <function _rename>, <class '<a href="../expressions.html#StrToMap">sqlglot.expressions.StrToMap</a>'>: <function _rename>, <class '<a href="../expressions.html#StrToTime">sqlglot.expressions.StrToTime</a>'>: <function _rename>, <class '<a href="../expressions.html#StrToUnix">sqlglot.expressions.StrToUnix</a>'>: <function _rename>, <class '<a href="../expressions.html#Struct">sqlglot.expressions.Struct</a>'>: <function _rename>, <class '<a href="../expressions.html#StructExtract">sqlglot.expressions.StructExtract</a>'>: <function _rename>, <class '<a href="../expressions.html#Stuff">sqlglot.expressions.Stuff</a>'>: <function _rename>, <class '<a href="../expressions.html#Substring">sqlglot.expressions.Substring</a>'>: <function _rename>, <class '<a href="../expressions.html#Sum">sqlglot.expressions.Sum</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeAdd">sqlglot.expressions.TimeAdd</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeDiff">sqlglot.expressions.TimeDiff</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeStrToDate">sqlglot.expressions.TimeStrToDate</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeStrToTime">sqlglot.expressions.TimeStrToTime</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeStrToUnix">sqlglot.expressions.TimeStrToUnix</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeSub">sqlglot.expressions.TimeSub</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeToStr">sqlglot.expressions.TimeToStr</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeToTimeStr">sqlglot.expressions.TimeToTimeStr</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeToUnix">sqlglot.expressions.TimeToUnix</a>'>: <function _rename>, <class '<a href="../expressions.html#TimeTrunc">sqlglot.expressions.TimeTrunc</a>'>: <function _rename>, <class '<a href="../expressions.html#Timestamp">sqlglot.expressions.Timestamp</a>'>: <function _rename>, <class '<a href="../expressions.html#TimestampAdd">sqlglot.expressions.TimestampAdd</a>'>: <function _rename>, <class '<a href="../expressions.html#TimestampDiff">sqlglot.expressions.TimestampDiff</a>'>: <function _rename>, <class '<a href="../expressions.html#TimestampFromParts">sqlglot.expressions.TimestampFromParts</a>'>: <function _rename>, <class '<a href="../expressions.html#TimestampSub">sqlglot.expressions.TimestampSub</a>'>: <function _rename>, <class '<a href="../expressions.html#TimestampTrunc">sqlglot.expressions.TimestampTrunc</a>'>: <function _rename>, <class '<a href="../expressions.html#ToBase64">sqlglot.expressions.ToBase64</a>'>: <function _rename>, <class '<a href="../expressions.html#ToChar">sqlglot.expressions.ToChar</a>'>: <function _rename>, <class '<a href="../expressions.html#ToDays">sqlglot.expressions.ToDays</a>'>: <function _rename>, <class '<a href="../expressions.html#Transform">sqlglot.expressions.Transform</a>'>: <function _rename>, <class '<a href="../expressions.html#Trim">sqlglot.expressions.Trim</a>'>: <function _rename>, <class '<a href="../expressions.html#TryCast">sqlglot.expressions.TryCast</a>'>: <function _rename>, <class '<a href="../expressions.html#TsOrDiToDi">sqlglot.expressions.TsOrDiToDi</a>'>: <function _rename>, <class '<a href="../expressions.html#TsOrDsAdd">sqlglot.expressions.TsOrDsAdd</a>'>: <function _rename>, <class '<a href="../expressions.html#TsOrDsDiff">sqlglot.expressions.TsOrDsDiff</a>'>: <function _rename>, <class '<a href="../expressions.html#TsOrDsToDate">sqlglot.expressions.TsOrDsToDate</a>'>: <function _rename>, <class '<a href="../expressions.html#TsOrDsToDateStr">sqlglot.expressions.TsOrDsToDateStr</a>'>: <function _rename>, <class '<a href="../expressions.html#Unhex">sqlglot.expressions.Unhex</a>'>: <function _rename>, <class '<a href="../expressions.html#UnixToStr">sqlglot.expressions.UnixToStr</a>'>: <function _rename>, <class '<a href="../expressions.html#UnixToTime">sqlglot.expressions.UnixToTime</a>'>: <function _rename>, <class '<a href="../expressions.html#UnixToTimeStr">sqlglot.expressions.UnixToTimeStr</a>'>: <function _rename>, <class '<a href="../expressions.html#Upper">sqlglot.expressions.Upper</a>'>: <function _rename>, <class '<a href="../expressions.html#VarMap">sqlglot.expressions.VarMap</a>'>: <function _rename>, <class '<a href="../expressions.html#Variance">sqlglot.expressions.Variance</a>'>: <function _rename>, <class '<a href="../expressions.html#VariancePop">sqlglot.expressions.VariancePop</a>'>: <function _rename>, <class '<a href="../expressions.html#Week">sqlglot.expressions.Week</a>'>: <function _rename>, <class '<a href="../expressions.html#WeekOfYear">sqlglot.expressions.WeekOfYear</a>'>: <function _rename>, <class '<a href="../expressions.html#When">sqlglot.expressions.When</a>'>: <function _rename>, <class '<a href="../expressions.html#XMLTable">sqlglot.expressions.XMLTable</a>'>: <function _rename>, <class '<a href="../expressions.html#Year">sqlglot.expressions.Year</a>'>: <function _rename>, <class '<a href="../expressions.html#Alias">sqlglot.expressions.Alias</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#Between">sqlglot.expressions.Between</a>'>: <function _rename>, <class '<a href="../expressions.html#Boolean">sqlglot.expressions.Boolean</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#Column">sqlglot.expressions.Column</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#Distinct">sqlglot.expressions.Distinct</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#In">sqlglot.expressions.In</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#Interval">sqlglot.expressions.Interval</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#Lambda">sqlglot.expressions.Lambda</a>'>: <function _lambda_sql>, <class '<a href="../expressions.html#Not">sqlglot.expressions.Not</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#Null">sqlglot.expressions.Null</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>, <class '<a href="../expressions.html#Ordered">sqlglot.expressions.Ordered</a>'>: <function _ordered_py>, <class '<a href="../expressions.html#Star">sqlglot.expressions.Star</a>'>: <function <a href="#Python.Generator">Python.Generator</a>.<lambda>>}</span> </div> @@ -2129,6 +2139,7 @@ Default: True</li> <dd id="Python.Generator.DATA_TYPE_SPECIFIERS_ALLOWED" class="variable"><a href="../generator.html#Generator.DATA_TYPE_SPECIFIERS_ALLOWED">DATA_TYPE_SPECIFIERS_ALLOWED</a></dd> <dd id="Python.Generator.ENSURE_BOOLS" class="variable"><a href="../generator.html#Generator.ENSURE_BOOLS">ENSURE_BOOLS</a></dd> <dd id="Python.Generator.CTE_RECURSIVE_KEYWORD_REQUIRED" class="variable"><a href="../generator.html#Generator.CTE_RECURSIVE_KEYWORD_REQUIRED">CTE_RECURSIVE_KEYWORD_REQUIRED</a></dd> + <dd id="Python.Generator.SUPPORTS_SINGLE_ARG_CONCAT" class="variable"><a href="../generator.html#Generator.SUPPORTS_SINGLE_ARG_CONCAT">SUPPORTS_SINGLE_ARG_CONCAT</a></dd> <dd id="Python.Generator.TYPE_MAPPING" class="variable"><a href="../generator.html#Generator.TYPE_MAPPING">TYPE_MAPPING</a></dd> <dd id="Python.Generator.STAR_MAPPING" class="variable"><a href="../generator.html#Generator.STAR_MAPPING">STAR_MAPPING</a></dd> <dd id="Python.Generator.TIME_PART_SINGULARS" class="variable"><a href="../generator.html#Generator.TIME_PART_SINGULARS">TIME_PART_SINGULARS</a></dd> @@ -2244,6 +2255,7 @@ Default: True</li> <dd id="Python.Generator.rowformatdelimitedproperty_sql" class="function"><a href="../generator.html#Generator.rowformatdelimitedproperty_sql">rowformatdelimitedproperty_sql</a></dd> <dd id="Python.Generator.withtablehint_sql" class="function"><a href="../generator.html#Generator.withtablehint_sql">withtablehint_sql</a></dd> <dd id="Python.Generator.indextablehint_sql" class="function"><a href="../generator.html#Generator.indextablehint_sql">indextablehint_sql</a></dd> + <dd id="Python.Generator.historicaldata_sql" class="function"><a href="../generator.html#Generator.historicaldata_sql">historicaldata_sql</a></dd> <dd id="Python.Generator.table_sql" class="function"><a href="../generator.html#Generator.table_sql">table_sql</a></dd> <dd id="Python.Generator.tablesample_sql" class="function"><a href="../generator.html#Generator.tablesample_sql">tablesample_sql</a></dd> <dd id="Python.Generator.pivot_sql" class="function"><a href="../generator.html#Generator.pivot_sql">pivot_sql</a></dd> @@ -2309,7 +2321,9 @@ Default: True</li> <dd id="Python.Generator.nextvaluefor_sql" class="function"><a href="../generator.html#Generator.nextvaluefor_sql">nextvaluefor_sql</a></dd> <dd id="Python.Generator.extract_sql" class="function"><a href="../generator.html#Generator.extract_sql">extract_sql</a></dd> <dd id="Python.Generator.trim_sql" class="function"><a href="../generator.html#Generator.trim_sql">trim_sql</a></dd> + <dd id="Python.Generator.convert_concat_args" class="function"><a href="../generator.html#Generator.convert_concat_args">convert_concat_args</a></dd> <dd id="Python.Generator.concat_sql" class="function"><a href="../generator.html#Generator.concat_sql">concat_sql</a></dd> + <dd id="Python.Generator.concatws_sql" class="function"><a href="../generator.html#Generator.concatws_sql">concatws_sql</a></dd> <dd id="Python.Generator.check_sql" class="function"><a href="../generator.html#Generator.check_sql">check_sql</a></dd> <dd id="Python.Generator.foreignkey_sql" class="function"><a href="../generator.html#Generator.foreignkey_sql">foreignkey_sql</a></dd> <dd id="Python.Generator.primarykey_sql" class="function"><a href="../generator.html#Generator.primarykey_sql">primarykey_sql</a></dd> |