import{s as Yt,d as s,i as l,a as it,b as n,e as r,h as Nt,f as c,g as ot,j as _,k as i,l as m,m as Ut,o as zt,p as Gt,q as Kt,r as Vt,n as ye,t as Wt,u as Xt,v as Jt}from"../chunks/scheduler.BpCfkKY9.js";import{S as Zt,i as es,d as te,t as se,a as le,m as ae,b as ne,e as re}from"../chunks/index.DgNprLIf.js";import{C as ie}from"../chunks/VennDiagram.svelte_svelte_type_style_lang.DWpnx7bK.js";import{w as ts}from"../chunks/entry.EhULRFQI.js";import{e as ss,s as ls,p as as,a as Ot,r as Bt,C as ns}from"../chunks/inferColumnTypes.DoTV3p49.js";import{p as rs}from"../chunks/stores.C2QhHszc.js";import{p as is}from"../chunks/profile.BW8tN6E9.js";function os(h){let d,p=w.title+"",u;return{c(){d=m("h1"),u=Jt(p),this.h()},l(o){d=c(o,"H1",{class:!0});var f=Wt(d);u=Xt(f,p),f.forEach(s),this.h()},h(){n(d,"class","title")},m(o,f){l(o,d,f),it(d,u)},p:ye,d(o){o&&s(d)}}}function us(h){return{c(){this.h()},l(d){this.h()},h(){document.title="Evidence"},m:ye,p:ye,d:ye}}function cs(h){let d,p,u,o,f;return document.title=d=w.title,{c(){p=i(),u=m("meta"),o=i(),f=m("meta"),this.h()},l(a){p=r(a),u=c(a,"META",{property:!0,content:!0}),o=r(a),f=c(a,"META",{name:!0,content:!0}),this.h()},h(){var a,y;n(u,"property","og:title"),n(u,"content",((a=w.og)==null?void 0:a.title)??w.title),n(f,"name","twitter:title"),n(f,"content",((y=w.og)==null?void 0:y.title)??w.title)},m(a,y){l(a,p,y),l(a,u,y),l(a,o,y),l(a,f,y)},p(a,y){y&0&&d!==(d=w.title)&&(document.title=d)},d(a){a&&(s(p),s(u),s(o),s(f))}}}function ms(h){var f;let d,p,u=ds(),o=((f=w.og)==null?void 0:f.image)&&fs();return{c(){u&&u.c(),d=i(),o&&o.c(),p=ot()},l(a){u&&u.l(a),d=r(a),o&&o.l(a),p=ot()},m(a,y){u&&u.m(a,y),l(a,d,y),o&&o.m(a,y),l(a,p,y)},p(a,y){var q;u.p(a,y),(q=w.og)!=null&&q.image&&o.p(a,y)},d(a){a&&(s(d),s(p)),u&&u.d(a),o&&o.d(a)}}}function ds(h){let d,p,u,o,f;return{c(){d=m("meta"),p=i(),u=m("meta"),o=i(),f=m("meta"),this.h()},l(a){d=c(a,"META",{name:!0,content:!0}),p=r(a),u=c(a,"META",{property:!0,content:!0}),o=r(a),f=c(a,"META",{name:!0,content:!0}),this.h()},h(){var a,y;n(d,"name","description"),n(d,"content",w.description),n(u,"property","og:description"),n(u,"content",((a=w.og)==null?void 0:a.description)??w.description),n(f,"name","twitter:description"),n(f,"content",((y=w.og)==null?void 0:y.description)??w.description)},m(a,y){l(a,d,y),l(a,p,y),l(a,u,y),l(a,o,y),l(a,f,y)},p:ye,d(a){a&&(s(d),s(p),s(u),s(o),s(f))}}}function fs(h){let d,p,u;return{c(){d=m("meta"),p=i(),u=m("meta"),this.h()},l(o){d=c(o,"META",{property:!0,content:!0}),p=r(o),u=c(o,"META",{name:!0,content:!0}),this.h()},h(){var o,f;n(d,"property","og:image"),n(d,"content",Ot((o=w.og)==null?void 0:o.image)),n(u,"name","twitter:image"),n(u,"content",Ot((f=w.og)==null?void 0:f.image))},m(o,f){l(o,d,f),l(o,p,f),l(o,u,f)},p:ye,d(o){o&&(s(d),s(p),s(u))}}}function ps(h){let d,p,u,o,f,a,y='<a href="#inline-queries">Inline Queries</a>',q,v,he='Evidence runs markdown code fences as SQL queries. These queries use the <a href="https://duckdb.org/docs/sql/introduction" rel="nofollow" class="markdown">DuckDB dialect</a>.',we,k,ve='If you have a data source called <code class="markdown">needful_things</code>, you run a query against it like this:',qe,oe,be,S,ut="When you open a page in dev mode, Evidence runs all of the queries on the page. In dev mode, Evidence monitors the contents of your SQL blocks, and reloads the page as necessary to reflect any changes you've made to your queries.",Te,E,ct="You include SQL queries in your page using a markdown code fence (starting and ending with 3 backticks). Evidence requires a query name to be supplied directly after the first 3 backticks.",Le,b,mt='<a href="#using-query-results">Using Query Results</a>',ge,j,dt='Reference a query in a component using <code class="markdown">data={query_name}</code>',Ce,A,ft='For example, if your query name was <code class="markdown">sales_by_category</code>:',xe,ue,He,T,pt='<a href="#query-chaining">Query Chaining</a>',Me,F,_t='Reference other queries by writing the query name inside <code class="markdown">${ }</code>.',$e,I,yt='For example, if you want to reference a query named <code class="markdown">sales_by_item</code>, you would write <code class="markdown">${sales_by_item}</code> into your SQL query, you would write:',Pe,ce,Qe,R,wt='Below is the compiled SQL that&#39;s sent to the database for <code class="markdown">average_sales</code>:',Se,me,Ee,L,kt='<a href="#view-compiled-sql">View Compiled SQL</a>',je,U,ht=`You can choose whether you want to see the compiled or written SQL inside the query viewer:
<img src="/img/compiled-written-toggle.gif" alt="compiled-written-toggle" class="markdown"/>`,Ae,g,vt='<a href="#ordering-and-circular-references">Ordering and Circular References</a>',Fe,O,qt="The order that queries appear on the page doesn't matter to the SQL compiler. You can reference queries that appear before or after the query that you are authoring.",Ie,B,bt='Some SQL dialects require sub-queries to be aliased, including Postgres and MySQL. E.g. <code class="markdown">from ${sales_by_item} as sales_by_item</code>.',Re,D,Tt="The SQL compiler detects circular and missing references. If a query includes either a circular reference or a missing reference, Evidence will display an error that looks like a syntax error in a normal SQL query. Queries with compiler errors are not sent to your database.",Ue,Y,Lt='<img src="/img/circular-error-single.png" alt="circular-error-single" class="markdown"/>',Oe,C,gt='<a href="#sql-file-queries">SQL File Queries</a>',Be,N,Ct="Evidence also has support for queries outside the markdown, which is especially useful when you have a query that is being used on more than one page.",De,x,xt='<a href="#basic-usage">Basic Usage</a>',Ye,z,Ht='To use sql file queries, you need to place them in the <code class="markdown">queries</code> directory, and then reference them in your <a href="/reference/markdown#frontmatter" class="markdown">frontmatter</a>.',Ne,G,Mt="An example setup could be:",ze,de,Ge,K,$t='These queries can then be used on <code class="markdown">my_page.md</code> with the following <a href="/reference/markdown#frontmatter" class="markdown">frontmatter</a>',Ke,fe,Ve,V,Pt='In your evidence file, you can now reference <code class="markdown">q4_data</code> and <code class="markdown">q4_sales_reps</code> the same way you would use any other query.',We,W,Qt='Optionally, you can omit the query name, and the filename will be used instead; these queries will be available at <code class="markdown">my_file_query</code> and <code class="markdown">some_category_my_category_file_query</code> (note that <code class="markdown">/</code> became <code class="markdown">_</code>).',Xe,pe,Je,H,St='<a href="#advanced-usage">Advanced Usage</a>',Ze,M,Et='<a href="#file-query-chaining">File Query Chaining</a>',et,X,jt='SQL file queries can <a href="/core-concepts/queries#query-chaining" class="markdown">depend on other query files</a>, but they will all need to be referenced in the files you use them in. For example, if <code class="markdown">my_file_query</code> depends on <code class="markdown">some_category_my_category_file_query</code>, then you will have to have them both in your <a href="/reference/markdown#frontmatter" class="markdown">frontmatter</a>, as shown above.',tt,$,At='<a href="#query-parameters">Query Parameters</a>',st,J,Ft='Queries can accept parameters, which might be from an input component such as a <a href="/components/inputs/dropdown" class="markdown">Dropdown</a>, or from a URL parameter on a <a href="/core-concepts/templated-pages" class="markdown">template page</a>.',lt,_e,at,Z,It="There are two types of parameters you can use in queries:",nt,ee,Rt='<li class="markdown"><strong class="markdown">Input parameters</strong> from components: <code class="markdown">&#39;${inputs.parameter_name}&#39;</code></li> <li class="markdown"><strong class="markdown">URL parameters</strong> from <a href="/core-concepts/templated-pages" class="markdown">templated pages</a>: <code class="markdown">&#39;${params.parameter_name}&#39;</code></li>',rt,P=typeof w<"u"&&w.title&&w.hide_title!==!0&&os();function Dt(e,t){return typeof w<"u"&&w.title?cs:us}let ke=Dt()(h),Q=typeof w=="object"&&ms();return oe=new ie({props:{source:"```sql sales_by_category\nselect \n  category, sum(sales) as sales\nfrom needful_things.orders\ngroup by 1\n```",copyToClipboard:"true",language:"markdown"}}),ue=new ie({props:{source:"<LineChart data={sales_by_category}/>",copyToClipboard:"true",language:"markdown"}}),ce=new ie({props:{source:"```sql sales_by_item\nselect\n    item,\n    sum(sales) as sales\nfrom needful_things.orders\ngroup by 1\n```\n\n```sql average_sales\nselect\n    avg(sales) as average_sales\nfrom ${sales_by_item}\n```",copyToClipboard:"true",language:"sql"}}),me=new ie({props:{source:`select
    avg(sales) as average_sales
from (
    select
        item,
        sum(sales) as sales
    from needful_things.orders
    group by 1
)`,copyToClipboard:"true",language:"sql"}}),de=new ie({props:{source:`my-evidence-project/
  pages/
    my_page.md
  queries/
    my_file_query.sql
    some_category/
        my_category_file_query.sql`,copyToClipboard:"true",language:"bash"}}),fe=new ie({props:{source:`---
queries:
  - q4_data: my_file_query.sql
  - q4_sales_reps: some_category/my_category_file_query.sql
---`,copyToClipboard:"true",language:"yaml"}}),pe=new ie({props:{source:`---
queries:
  - my_file_query.sql
  - some_category/my_category_file_query.sql
---`,copyToClipboard:"true",language:"yaml"}}),_e=new ie({props:{source:"```sql sales_by_month\nselect\n    date_trunc('month', date) as month,\n    sum(sales) as sales\nfrom needful_things.orders\nwhere category = '${inputs.category}'\ngroup by 1\n```",copyToClipboard:"true",language:"markdown"}}),{c(){P&&P.c(),d=i(),ke.c(),p=m("meta"),u=m("meta"),Q&&Q.c(),o=ot(),f=i(),a=m("h2"),a.innerHTML=y,q=i(),v=m("p"),v.innerHTML=he,we=i(),k=m("p"),k.innerHTML=ve,qe=i(),re(oe.$$.fragment),be=i(),S=m("p"),S.textContent=ut,Te=i(),E=m("p"),E.textContent=ct,Le=i(),b=m("h3"),b.innerHTML=mt,ge=i(),j=m("p"),j.innerHTML=dt,Ce=i(),A=m("p"),A.innerHTML=ft,xe=i(),re(ue.$$.fragment),He=i(),T=m("h2"),T.innerHTML=pt,Me=i(),F=m("p"),F.innerHTML=_t,$e=i(),I=m("p"),I.innerHTML=yt,Pe=i(),re(ce.$$.fragment),Qe=i(),R=m("p"),R.innerHTML=wt,Se=i(),re(me.$$.fragment),Ee=i(),L=m("h3"),L.innerHTML=kt,je=i(),U=m("p"),U.innerHTML=ht,Ae=i(),g=m("h3"),g.innerHTML=vt,Fe=i(),O=m("p"),O.textContent=qt,Ie=i(),B=m("p"),B.innerHTML=bt,Re=i(),D=m("p"),D.textContent=Tt,Ue=i(),Y=m("p"),Y.innerHTML=Lt,Oe=i(),C=m("h2"),C.innerHTML=gt,Be=i(),N=m("p"),N.textContent=Ct,De=i(),x=m("h3"),x.innerHTML=xt,Ye=i(),z=m("p"),z.innerHTML=Ht,Ne=i(),G=m("p"),G.textContent=Mt,ze=i(),re(de.$$.fragment),Ge=i(),K=m("p"),K.innerHTML=$t,Ke=i(),re(fe.$$.fragment),Ve=i(),V=m("p"),V.innerHTML=Pt,We=i(),W=m("p"),W.innerHTML=Qt,Xe=i(),re(pe.$$.fragment),Je=i(),H=m("h3"),H.innerHTML=St,Ze=i(),M=m("h4"),M.innerHTML=Et,et=i(),X=m("p"),X.innerHTML=jt,tt=i(),$=m("h2"),$.innerHTML=At,st=i(),J=m("p"),J.innerHTML=Ft,lt=i(),re(_e.$$.fragment),at=i(),Z=m("p"),Z.textContent=It,nt=i(),ee=m("ul"),ee.innerHTML=Rt,this.h()},l(e){P&&P.l(e),d=r(e);const t=Nt("svelte-2igo1p",document.head);ke.l(t),p=c(t,"META",{name:!0,content:!0}),u=c(t,"META",{name:!0,content:!0}),Q&&Q.l(t),o=ot(),t.forEach(s),f=r(e),a=c(e,"H2",{class:!0,id:!0,"data-svelte-h":!0}),_(a)!=="svelte-1uox0uj"&&(a.innerHTML=y),q=r(e),v=c(e,"P",{class:!0,"data-svelte-h":!0}),_(v)!=="svelte-js0r9s"&&(v.innerHTML=he),we=r(e),k=c(e,"P",{class:!0,"data-svelte-h":!0}),_(k)!=="svelte-cnebnt"&&(k.innerHTML=ve),qe=r(e),ne(oe.$$.fragment,e),be=r(e),S=c(e,"P",{class:!0,"data-svelte-h":!0}),_(S)!=="svelte-1e6h7mq"&&(S.textContent=ut),Te=r(e),E=c(e,"P",{class:!0,"data-svelte-h":!0}),_(E)!=="svelte-1crb9fh"&&(E.textContent=ct),Le=r(e),b=c(e,"H3",{class:!0,id:!0,"data-svelte-h":!0}),_(b)!=="svelte-fy4qug"&&(b.innerHTML=mt),ge=r(e),j=c(e,"P",{class:!0,"data-svelte-h":!0}),_(j)!=="svelte-12w40sn"&&(j.innerHTML=dt),Ce=r(e),A=c(e,"P",{class:!0,"data-svelte-h":!0}),_(A)!=="svelte-39n5j7"&&(A.innerHTML=ft),xe=r(e),ne(ue.$$.fragment,e),He=r(e),T=c(e,"H2",{class:!0,id:!0,"data-svelte-h":!0}),_(T)!=="svelte-15t8ult"&&(T.innerHTML=pt),Me=r(e),F=c(e,"P",{class:!0,"data-svelte-h":!0}),_(F)!=="svelte-1qvo8vv"&&(F.innerHTML=_t),$e=r(e),I=c(e,"P",{class:!0,"data-svelte-h":!0}),_(I)!=="svelte-5d4w4e"&&(I.innerHTML=yt),Pe=r(e),ne(ce.$$.fragment,e),Qe=r(e),R=c(e,"P",{class:!0,"data-svelte-h":!0}),_(R)!=="svelte-60lull"&&(R.innerHTML=wt),Se=r(e),ne(me.$$.fragment,e),Ee=r(e),L=c(e,"H3",{class:!0,id:!0,"data-svelte-h":!0}),_(L)!=="svelte-1k7k95y"&&(L.innerHTML=kt),je=r(e),U=c(e,"P",{class:!0,"data-svelte-h":!0}),_(U)!=="svelte-15pyah8"&&(U.innerHTML=ht),Ae=r(e),g=c(e,"H3",{class:!0,id:!0,"data-svelte-h":!0}),_(g)!=="svelte-ioy2bg"&&(g.innerHTML=vt),Fe=r(e),O=c(e,"P",{class:!0,"data-svelte-h":!0}),_(O)!=="svelte-1d7fj4g"&&(O.textContent=qt),Ie=r(e),B=c(e,"P",{class:!0,"data-svelte-h":!0}),_(B)!=="svelte-1ymhj4w"&&(B.innerHTML=bt),Re=r(e),D=c(e,"P",{class:!0,"data-svelte-h":!0}),_(D)!=="svelte-1lmvdt7"&&(D.textContent=Tt),Ue=r(e),Y=c(e,"P",{class:!0,"data-svelte-h":!0}),_(Y)!=="svelte-1qr7xhq"&&(Y.innerHTML=Lt),Oe=r(e),C=c(e,"H2",{class:!0,id:!0,"data-svelte-h":!0}),_(C)!=="svelte-972gfq"&&(C.innerHTML=gt),Be=r(e),N=c(e,"P",{class:!0,"data-svelte-h":!0}),_(N)!=="svelte-1jsyf72"&&(N.textContent=Ct),De=r(e),x=c(e,"H3",{class:!0,id:!0,"data-svelte-h":!0}),_(x)!=="svelte-1cu6sxz"&&(x.innerHTML=xt),Ye=r(e),z=c(e,"P",{class:!0,"data-svelte-h":!0}),_(z)!=="svelte-w80ire"&&(z.innerHTML=Ht),Ne=r(e),G=c(e,"P",{class:!0,"data-svelte-h":!0}),_(G)!=="svelte-172uah8"&&(G.textContent=Mt),ze=r(e),ne(de.$$.fragment,e),Ge=r(e),K=c(e,"P",{class:!0,"data-svelte-h":!0}),_(K)!=="svelte-1kye12v"&&(K.innerHTML=$t),Ke=r(e),ne(fe.$$.fragment,e),Ve=r(e),V=c(e,"P",{class:!0,"data-svelte-h":!0}),_(V)!=="svelte-1vyyj9e"&&(V.innerHTML=Pt),We=r(e),W=c(e,"P",{class:!0,"data-svelte-h":!0}),_(W)!=="svelte-1ex2cc6"&&(W.innerHTML=Qt),Xe=r(e),ne(pe.$$.fragment,e),Je=r(e),H=c(e,"H3",{class:!0,id:!0,"data-svelte-h":!0}),_(H)!=="svelte-1ryqxiv"&&(H.innerHTML=St),Ze=r(e),M=c(e,"H4",{class:!0,id:!0,"data-svelte-h":!0}),_(M)!=="svelte-13grwh7"&&(M.innerHTML=Et),et=r(e),X=c(e,"P",{class:!0,"data-svelte-h":!0}),_(X)!=="svelte-2p06ij"&&(X.innerHTML=jt),tt=r(e),$=c(e,"H2",{class:!0,id:!0,"data-svelte-h":!0}),_($)!=="svelte-ckdzps"&&($.innerHTML=At),st=r(e),J=c(e,"P",{class:!0,"data-svelte-h":!0}),_(J)!=="svelte-8y5ahu"&&(J.innerHTML=Ft),lt=r(e),ne(_e.$$.fragment,e),at=r(e),Z=c(e,"P",{class:!0,"data-svelte-h":!0}),_(Z)!=="svelte-5ayf0f"&&(Z.textContent=It),nt=r(e),ee=c(e,"UL",{class:!0,"data-svelte-h":!0}),_(ee)!=="svelte-1p8w2ib"&&(ee.innerHTML=Rt),this.h()},h(){n(p,"name","twitter:card"),n(p,"content","summary_large_image"),n(u,"name","twitter:site"),n(u,"content","@evidence_dev"),n(a,"class","markdown"),n(a,"id","inline-queries"),n(v,"class","markdown"),n(k,"class","markdown"),n(S,"class","markdown"),n(E,"class","markdown"),n(b,"class","markdown"),n(b,"id","using-query-results"),n(j,"class","markdown"),n(A,"class","markdown"),n(T,"class","markdown"),n(T,"id","query-chaining"),n(F,"class","markdown"),n(I,"class","markdown"),n(R,"class","markdown"),n(L,"class","markdown"),n(L,"id","view-compiled-sql"),n(U,"class","markdown"),n(g,"class","markdown"),n(g,"id","ordering-and-circular-references"),n(O,"class","markdown"),n(B,"class","markdown"),n(D,"class","markdown"),n(Y,"class","markdown"),n(C,"class","markdown"),n(C,"id","sql-file-queries"),n(N,"class","markdown"),n(x,"class","markdown"),n(x,"id","basic-usage"),n(z,"class","markdown"),n(G,"class","markdown"),n(K,"class","markdown"),n(V,"class","markdown"),n(W,"class","markdown"),n(H,"class","markdown"),n(H,"id","advanced-usage"),n(M,"class","markdown"),n(M,"id","file-query-chaining"),n(X,"class","markdown"),n($,"class","markdown"),n($,"id","query-parameters"),n(J,"class","markdown"),n(Z,"class","markdown"),n(ee,"class","markdown")},m(e,t){P&&P.m(e,t),l(e,d,t),ke.m(document.head,null),it(document.head,p),it(document.head,u),Q&&Q.m(document.head,null),it(document.head,o),l(e,f,t),l(e,a,t),l(e,q,t),l(e,v,t),l(e,we,t),l(e,k,t),l(e,qe,t),ae(oe,e,t),l(e,be,t),l(e,S,t),l(e,Te,t),l(e,E,t),l(e,Le,t),l(e,b,t),l(e,ge,t),l(e,j,t),l(e,Ce,t),l(e,A,t),l(e,xe,t),ae(ue,e,t),l(e,He,t),l(e,T,t),l(e,Me,t),l(e,F,t),l(e,$e,t),l(e,I,t),l(e,Pe,t),ae(ce,e,t),l(e,Qe,t),l(e,R,t),l(e,Se,t),ae(me,e,t),l(e,Ee,t),l(e,L,t),l(e,je,t),l(e,U,t),l(e,Ae,t),l(e,g,t),l(e,Fe,t),l(e,O,t),l(e,Ie,t),l(e,B,t),l(e,Re,t),l(e,D,t),l(e,Ue,t),l(e,Y,t),l(e,Oe,t),l(e,C,t),l(e,Be,t),l(e,N,t),l(e,De,t),l(e,x,t),l(e,Ye,t),l(e,z,t),l(e,Ne,t),l(e,G,t),l(e,ze,t),ae(de,e,t),l(e,Ge,t),l(e,K,t),l(e,Ke,t),ae(fe,e,t),l(e,Ve,t),l(e,V,t),l(e,We,t),l(e,W,t),l(e,Xe,t),ae(pe,e,t),l(e,Je,t),l(e,H,t),l(e,Ze,t),l(e,M,t),l(e,et,t),l(e,X,t),l(e,tt,t),l(e,$,t),l(e,st,t),l(e,J,t),l(e,lt,t),ae(_e,e,t),l(e,at,t),l(e,Z,t),l(e,nt,t),l(e,ee,t),rt=!0},p(e,[t]){typeof w<"u"&&w.title&&w.hide_title!==!0&&P.p(e,t),ke.p(e,t),typeof w=="object"&&Q.p(e,t)},i(e){rt||(le(oe.$$.fragment,e),le(ue.$$.fragment,e),le(ce.$$.fragment,e),le(me.$$.fragment,e),le(de.$$.fragment,e),le(fe.$$.fragment,e),le(pe.$$.fragment,e),le(_e.$$.fragment,e),rt=!0)},o(e){se(oe.$$.fragment,e),se(ue.$$.fragment,e),se(ce.$$.fragment,e),se(me.$$.fragment,e),se(de.$$.fragment,e),se(fe.$$.fragment,e),se(pe.$$.fragment,e),se(_e.$$.fragment,e),rt=!1},d(e){e&&(s(d),s(f),s(a),s(q),s(v),s(we),s(k),s(qe),s(be),s(S),s(Te),s(E),s(Le),s(b),s(ge),s(j),s(Ce),s(A),s(xe),s(He),s(T),s(Me),s(F),s($e),s(I),s(Pe),s(Qe),s(R),s(Se),s(Ee),s(L),s(je),s(U),s(Ae),s(g),s(Fe),s(O),s(Ie),s(B),s(Re),s(D),s(Ue),s(Y),s(Oe),s(C),s(Be),s(N),s(De),s(x),s(Ye),s(z),s(Ne),s(G),s(ze),s(Ge),s(K),s(Ke),s(Ve),s(V),s(We),s(W),s(Xe),s(Je),s(H),s(Ze),s(M),s(et),s(X),s(tt),s($),s(st),s(J),s(lt),s(at),s(Z),s(nt),s(ee)),P&&P.d(e),ke.d(e),s(p),s(u),Q&&Q.d(e),s(o),te(oe,e),te(ue,e),te(ce,e),te(me,e),te(de,e),te(fe,e),te(pe,e),te(_e,e)}}}const w={title:"SQL Queries",description:"Markdown code fences run SQL queries, and return the results as data for components."};function _s(h,d,p){let u,o;Ut(h,rs,k=>p(2,u=k)),Ut(h,Bt,k=>p(8,o=k));let{data:f}=d,{data:a={},customFormattingSettings:y,__db:q,inputs:v}=f;zt(Bt,o="fdd629808add7f58cf49f045c4b7c198",o);let he=ss(ts(v));return Gt(he.subscribe(k=>v=k)),Kt(ns,{getCustomFormats:()=>y.customFormats||[]}),ls((k,ve)=>is(q.query,k,{query_name:ve})),u.params,Vt(()=>!0),h.$$set=k=>{"data"in k&&p(0,f=k.data)},h.$$.update=()=>{h.$$.dirty&1&&p(1,{data:a={},customFormattingSettings:y,__db:q}=f,a),h.$$.dirty&2&&as.set(Object.keys(a).length>0),h.$$.dirty&4&&u.params},[f,a,u]}class Ls extends Zt{constructor(d){super(),es(this,d,_s,ps,Yt,{data:0})}}export{Ls as component};