{"id":6106,"date":"2026-08-30T12:30:38","date_gmt":"2026-08-30T17:30:38","guid":{"rendered":"https:\/\/querystreams.com\/database-integrations\/multi-record-csv-integrations\/"},"modified":"2026-10-12T21:48:36","modified_gmt":"2026-10-13T02:48:36","slug":"multi-record-csv","status":"publish","type":"page","link":"https:\/\/querystreams.com\/nl\/database-integrations\/multi-record-csv\/","title":{"rendered":"Integraties van CSV-bestanden met meerdere records"},"content":{"rendered":"<link rel=\"preconnect\" href=\"https:\/\/fonts.googleapis.com\"><link rel=\"preconnect\" href=\"https:\/\/fonts.gstatic.com\" crossorigin><link href=\"https:\/\/fonts.googleapis.com\/css2?family=Inter:wght@400;500;600;700;800&family=JetBrains+Mono:wght@400;500;700&display=swap\" rel=\"stylesheet\"><link rel=\"stylesheet\" href=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/font-awesome\/6.5.2\/css\/all.min.css\"><style>\n\/* Hallmark \u00b7 QueryStreams PORTAL v4 (homepage standard) \u00b7 page: Connector Hub \u00b7 #qspx-connector-hub\n * pre-emit critique: P5 H5 E4 S5 R5 V4\n *\n * SYSTEM-MANAGED PAGE -- diversification is INVERTED here.\n * \/database-integrations\/ is #qspx-connectors, connectors-v4. These hubs are its\n * children, so they must read as the same site, not as a fresh design. The token\n * block below is copied VERBATIM from that page; the shared component rules\n * (.qspx-wrap \/ -btn \/ -link \/ -section \/ -shead \/ -hero \/ -step \/ -cta) are the\n * same rules, same values. Only the .qch-* block is new, and it is new only\n * because the parent has no destination-matrix component to borrow.\n *\n * Every v4 page ships its own copy of this CSS inside its widget -- that is the\n * established delivery, not an oversight. Do not \"de-duplicate\" it into the\n * Customizer sheet without moving all of them at once.\n *\/\n#qspx-connector-hub,#qspx-connector-hub *{box-sizing:border-box}\n#qspx-connector-hub{\n  --bg:oklch(27% 0.03 256);--bg-900:oklch(21% 0.04 264);--bg-950:oklch(15% 0.045 265);\n  --glass:oklch(40% 0.03 256 \/ .42);--glass-2:oklch(30% 0.035 258 \/ .55);\n  --border:oklch(100% 0 0 \/ .12);--border-2:oklch(100% 0 0 \/ .22);\n  --ink:oklch(96% 0.005 250);--ink-2:oklch(85% 0.02 256);--ink-3:oklch(70% 0.03 256);\n  --emerald:oklch(64% 0.16 158);--emerald-2:oklch(54% 0.14 155);--emerald-bright:oklch(74% 0.16 158);\n  --ico:oklch(82% 0.13 162);--emerald-soft:oklch(64% 0.16 158 \/ .15);--emerald-line:oklch(64% 0.16 158 \/ .30);\n  --star:oklch(83% 0.15 85);--focus:oklch(74% 0.16 158);--maxw:1180px;--pad:clamp(1.15rem,4vw,2.5rem);\n  --amber:oklch(83% 0.15 85 \/ .16);--amber-line:oklch(83% 0.15 85 \/ .34);\n  --font-d:\"Inter\",-apple-system,BlinkMacSystemFont,\"Segoe UI\",Roboto,sans-serif;\n  --font-b:\"Inter\",-apple-system,BlinkMacSystemFont,\"Segoe UI\",Roboto,sans-serif;\n  --font-m:\"JetBrains Mono\",ui-monospace,SFMono-Regular,Menlo,Consolas,monospace;\n  --ease:cubic-bezier(0.16,1,0.3,1);\n  position:relative;left:50%;margin-left:-50vw;width:100vw;max-width:100vw;overflow-x:clip;isolation:isolate;\n  background:linear-gradient(150deg,#334155 0%,#1e293b 58%,#172230 100%);\n  color:var(--ink);font-family:var(--font-b);font-size:1.05rem;line-height:1.6;\n  -webkit-font-smoothing:antialiased;text-rendering:optimizeLegibility}\nhtml,body{overflow-x:clip}\nhtml body{background:#172230}\n\nhtml,#qspx-connector-hub,#qspx-connector-hub *{scrollbar-width:thin;\n  scrollbar-color:oklch(48% 0.045 258) oklch(17% 0.04 264)}\nhtml{scrollbar-gutter:stable}\nhtml::-webkit-scrollbar,#qspx-connector-hub ::-webkit-scrollbar{width:12px;height:12px}\nhtml::-webkit-scrollbar-track,#qspx-connector-hub ::-webkit-scrollbar-track{background:oklch(17% 0.04 264)}\nhtml::-webkit-scrollbar-thumb,#qspx-connector-hub ::-webkit-scrollbar-thumb{\n  background:oklch(48% 0.045 258);border-radius:999px;border:3px solid oklch(17% 0.04 264)}\nhtml::-webkit-scrollbar-thumb:hover,#qspx-connector-hub ::-webkit-scrollbar-thumb:hover{background:oklch(64% 0.16 158)}\nhtml::-webkit-scrollbar-button,#qspx-connector-hub ::-webkit-scrollbar-button{display:none;width:0;height:0}\n\n.site-footer,.site-footer>*,.site-primary-footer-wrap,.site-below-footer-wrap,\n.ast-small-footer,.ast-small-footer-wrap,.ast-below-footer-wrap,\n[data-section=\"section-below-footer-builder\"]{border-top-width:0!important;box-shadow:none!important}\n\n#qspx-connector-hub::before{content:\"\";position:absolute;inset:0;z-index:0;pointer-events:none;\n  background:\n    linear-gradient(rgba(255,255,255,0.04) 1px,transparent 1px) 0 0\/52px 52px,\n    linear-gradient(90deg,rgba(255,255,255,0.04) 1px,transparent 1px) 0 0\/52px 52px,\n    radial-gradient(900px 620px at 8% 1%, rgba(16,124,65,0.22) 0%, transparent 70%),\n    radial-gradient(760px 520px at 97% 4%, rgba(16,124,65,0.13) 0%, transparent 72%),\n    radial-gradient(960px 640px at 95% 99%, rgba(15,157,88,0.18) 0%, transparent 72%),\n    linear-gradient(150deg, rgba(16,185,129,0.11) 0%, transparent 46%, rgba(6,182,212,0.13) 100%)}\n#qspx-connector-hub>*{position:relative;z-index:1}\n\n#qspx-connector-hub h1,#qspx-connector-hub h2,#qspx-connector-hub h3,#qspx-connector-hub h4{\n  font-family:var(--font-d);font-weight:700;line-height:1.13;letter-spacing:-0.02em;color:var(--ink);\n  margin:0;text-wrap:balance;overflow-wrap:anywhere;min-width:0}\n#qspx-connector-hub p{margin:0}\n#qspx-connector-hub ul,#qspx-connector-hub ol{list-style:none;margin:0;padding:0}\n#qspx-connector-hub a{color:inherit;text-decoration:none}\n#qspx-connector-hub img{max-width:100%;height:auto;display:block}\n#qspx-connector-hub code{font-family:var(--font-m);font-size:.86em;background:oklch(64% 0.16 158 \/ .12);\n  color:var(--ico);padding:1px 6px;border-radius:5px}\n#qspx-connector-hub :focus-visible{outline:2px solid var(--focus);outline-offset:3px;border-radius:8px}\n#qspx-connector-hub .qspx-wrap{max-width:var(--maxw);margin-inline:auto;padding-inline:var(--pad)}\n.qspx-hl{color:var(--emerald-bright)}\n\n\/* buttons \/ links -- canonical v4 *\/\n.qspx-btn{display:inline-flex;align-items:center;justify-content:center;gap:.5rem;font-family:var(--font-d);font-weight:600;\n  font-size:.95rem;padding:.8rem 1.5rem;border-radius:11px;border:1px solid transparent;cursor:pointer;white-space:nowrap;\n  transition:transform .18s var(--ease),box-shadow .18s var(--ease),background .18s var(--ease),border-color .18s var(--ease)}\n.qspx-btn i{font-size:.85rem;transition:transform .18s var(--ease)}\n.qspx-btn-primary{background:linear-gradient(135deg,var(--emerald),var(--emerald-2));color:var(--ink);\n  box-shadow:0 8px 24px -8px oklch(64% 0.16 158 \/ .55)}\n.qspx-btn-primary:hover{transform:translateY(-2px);box-shadow:0 14px 32px -8px oklch(64% 0.16 158 \/ .7)}\n.qspx-btn-primary:hover i{transform:translateX(3px)}\n.qspx-btn-ghost{background:oklch(100% 0 0 \/ .04);color:var(--ink);border-color:var(--border-2)}\n.qspx-btn-ghost:hover{background:oklch(100% 0 0 \/ .1);border-color:var(--emerald-line);transform:translateY(-2px)}\n.qspx-link{display:inline-flex;align-items:center;gap:.4rem;font-family:var(--font-d);font-weight:600;font-size:.92rem;\n  color:var(--emerald-bright);transition:gap .18s var(--ease)}\n.qspx-link:hover{gap:.7rem}\n\n\/* section scaffolding -- canonical v4 *\/\n.qspx-section{padding-block:clamp(3.5rem,7vw,5.5rem)}\n.qspx-shead{display:flex;flex-direction:column;gap:.8rem;align-items:center;text-align:center;max-width:48rem;\n  margin-inline:auto;margin-bottom:clamp(2rem,4vw,3rem);padding-inline:var(--pad)}\n.qspx-h2{font-size:clamp(1.85rem,3.4vw,2.7rem);font-weight:700;letter-spacing:-0.025em;max-width:min(24ch,100%)}\n.qspx-shead p{color:var(--ink-2);font-size:1.05rem;max-width:min(56ch,100%);line-height:1.6}\n.qspx-eyebrow{font-family:var(--font-m);font-size:.74rem;letter-spacing:.16em;text-transform:uppercase;color:var(--ico)}\n\n\/* hero -- canonical v4 *\/\n.qspx-hero{padding-block:clamp(2.25rem,6vw,4rem) clamp(1.6rem,3vw,2.4rem);text-align:center}\n.qspx-hero-inner{display:flex;flex-direction:column;align-items:center;gap:1.2rem;max-width:56rem;\n  margin-inline:auto;padding-inline:var(--pad)}\n\/* min(Nch,100%) not bare Nch: these are centred flex items, so a `ch` cap wider\n   than the padded container makes the item overflow the page instead of\n   wrapping (Hallmark gate 34 -- no horizontal scroll at 320\/375\/414\/768). *\/\n.qspx-h1{font-size:clamp(2.1rem,4.4vw,3.4rem);font-weight:800;letter-spacing:-0.03em;line-height:1.05;\n  max-width:min(20ch,100%)}\n.qspx-lede{font-size:clamp(1.05rem,1.4vw,1.25rem);line-height:1.55;color:var(--ink-2);\n  max-width:min(62ch,100%);font-weight:400}\n.qspx-ctas{display:flex;flex-wrap:wrap;gap:.75rem;justify-content:center;margin-top:.3rem}\n\/* .qcn-counts (1 connection \/ 0 ports \/ read-only) retired 2026-09-30: the three\n   claims now live on the agent node of the fan-out diagram. *\/\n.qcn-counts{display:flex;flex-wrap:wrap;justify-content:center;gap:.6rem;margin-top:.5rem}\n#qspx-connector-hub .qcn-counts .c{display:inline-flex;align-items:baseline;gap:.45rem;background:var(--glass-2);\n  border:1px solid var(--border);border-radius:999px;padding:.4rem .9rem;\n  backdrop-filter:blur(10px);-webkit-backdrop-filter:blur(10px)}\n.qcn-counts .c b{font-family:var(--font-m);font-weight:700;font-size:1.05rem;color:var(--ico);line-height:1}\n.qcn-counts .c span{font-family:var(--font-m);font-size:.7rem;letter-spacing:.08em;text-transform:uppercase;color:var(--ink-3)}\n\n\/* \u2500\u2500 HUB-SPECIFIC (.qch-*) \u2500\u2500 the parent page has no equivalent component \u2500\u2500 *\/\n\n\/* Breadcrumb. Mono, tiny, one line -- it is orientation, not navigation\n   furniture, and it must never wrap a link onto two lines (gate 49). *\/\n.qch-crumbs{display:flex;flex-wrap:wrap;align-items:center;gap:.45rem;justify-content:center;\n  max-width:var(--maxw);margin-inline:auto;padding:1.4rem var(--pad) 0;\n  font-family:var(--font-m);font-size:.72rem;letter-spacing:.04em;color:var(--ink-3)}\n.qch-crumbs a{white-space:nowrap;transition:color .18s var(--ease)}\n.qch-crumbs a:hover{color:var(--ico)}\n.qch-crumbs [aria-current]{color:var(--ink-2);white-space:nowrap}\n.qch-crumbs i{font-size:.55rem;opacity:.5}\n\n\/* Vendor mark. Same 40px art the directory cards use, on a raised tile so a\n   white-on-white logo (Snowflake, SQL Server) survives the dark ground. *\/\n.qch-mark{width:84px;height:84px;display:grid;place-items:center;border-radius:20px;\n  background:linear-gradient(150deg,oklch(31% 0.038 260),oklch(23% 0.042 264));\n  border:1px solid var(--border-2);position:relative;overflow:hidden;\n  box-shadow:0 16px 34px -14px rgba(2,8,23,.8),inset 0 1px 0 oklch(100% 0 0 \/ .10)}\n.qch-mark::after{content:\"\";position:absolute;inset:0;pointer-events:none;\n  background:radial-gradient(circle at 50% 42%,color-mix(in oklab,var(--c2) 26%,transparent) 0%,transparent 68%)}\n#qspx-connector-hub .qch-mark img{position:relative;z-index:1;width:46px;height:46px;object-fit:contain}\n.qch-kindrow{display:inline-flex;flex-wrap:wrap;align-items:center;gap:.5rem;justify-content:center}\n.qch-chip{font-family:var(--font-m);font-size:.62rem;letter-spacing:.07em;text-transform:uppercase;\n  padding:.24rem .6rem;border-radius:999px;line-height:1.4;\n  color:var(--ink-2);background:var(--glass-2);border:1px solid var(--border)}\n.qch-chip-new{color:var(--ink);background:var(--emerald-soft);border-color:var(--emerald-line)}\n\n\/* Answer panel -- ONE container for the capsule and (presets only) the\n   wire-protocol note. The capsule is the 40-80 word liftable block: its own\n   <p>, prose register, --ink-2. The note is a caveat, so it sits INSIDE the\n   same panel as a footer row -- smaller, --ink-3, divided by a hairline --\n   rather than as a second stacked callout. No accent rail: a full-height\n   colored left border is the stock admonition-callout look (user call\n   2026-08-30) -- the mono eyebrow and the note icon carry the register. *\/\n#qspx-connector-hub .qch-answer{position:relative;max-width:min(78ch,100%);\n  margin:clamp(1.6rem,3.5vw,2.4rem) auto 0;padding:1.2rem 1.5rem 1.15rem;\n  background:linear-gradient(180deg,var(--glass),var(--glass-2));\n  border:1px solid var(--border-2);border-radius:16px;overflow:hidden}\n#qspx-connector-hub .qch-answer-ey{font-family:var(--font-m);font-size:.62rem;font-weight:500;\n  letter-spacing:.16em;text-transform:uppercase;color:var(--ico);margin-bottom:.6rem}\n#qspx-connector-hub .qch-capsule{font-size:.98rem;line-height:1.7;color:var(--ink-2);text-wrap:pretty}\n#qspx-connector-hub .qch-answer-note{display:flex;gap:.7rem;align-items:flex-start;\n  margin-top:1.05rem;padding-top:1.05rem;border-top:1px solid var(--border);\n  font-size:.88rem;line-height:1.6;color:var(--ink-3)}\n#qspx-connector-hub .qch-answer-note i{color:var(--emerald-bright);margin-top:.22rem;font-size:.82rem}\n#qspx-connector-hub .qch-answer-note b{color:var(--ink-2);font-weight:600}\n#qspx-connector-hub .qch-answer-note a{color:var(--emerald-bright);border-bottom:1px solid var(--emerald-line)}\n\n\/* Fan-out -- the page's reason to exist (2026-09-30, replaced the 3x4 card grid\n   and the standalone capsule panel; user ruling: \"show the product, not cards\").\n   One diagram: source node -> Network Agent -> destination nodes grouped by\n   AUDIENCE, drawn from the same $rows the list and the JSON-LD use. Under it the\n   AI-liftable capsule (unchanged in purpose, smaller in type) and the family \/\n   wire-protocol note as chips. Then ONE panel of hairline rows -- the pair\n   heading (the ranking phrase) stays an h3, so nothing the cards ranked for is\n   lost. Lines are an SVG the inline script draws from the nodes' positions. *\/\n.qch-fan{padding-block:clamp(1.2rem,3vw,2rem) clamp(3rem,6vw,4.5rem)}\n.qch-fan .qspx-shead{margin-bottom:clamp(1.2rem,2.5vw,1.8rem)}\n.qch-fan-diagram{position:relative;display:grid;grid-template-columns:auto auto minmax(300px,1fr);\n  align-items:center;column-gap:clamp(2.5rem,6vw,5.5rem);padding:clamp(1rem,2.5vw,1.6rem) clamp(1.2rem,3vw,2.2rem);\n  background:var(--glass);border:1px solid var(--border-2);border-radius:20px;overflow:hidden;\n  box-shadow:0 30px 60px -30px rgba(2,8,23,.7)}\n.qch-fan-diagram::before{content:\"\";position:absolute;inset:0;pointer-events:none;\n  background:radial-gradient(520px 260px at 12% 50%, color-mix(in oklab,var(--c2) 14%,transparent) 0%, transparent 70%)}\n.qch-fan-lines{position:absolute;inset:0;width:100%;height:100%;pointer-events:none;overflow:visible}\n.qch-fan-lines path{fill:none;stroke:oklch(100% 0 0 \/ .18);stroke-width:1.5;transition:stroke .25s var(--ease),stroke-width .25s var(--ease)}\n.qch-fan-lines path.is-hot{stroke:var(--emerald-bright);stroke-width:2.5;filter:drop-shadow(0 0 6px oklch(64% 0.16 158 \/ .6))}\n.qch-fan-lines path.is-flow{stroke-dasharray:4 10;animation:qchflow 1.6s linear infinite}\n@keyframes qchflow{to{stroke-dashoffset:-14}}\n\n\/* Source column: the connector's mark, a family glyph (workbook stack for folders,\n   a table for everything else) and the one-line \"what happens\" caption -- plus\n   a dashed ghost source for federation (other connectors join this one in one\n   SQL statement; the result leaves through the same destinations). *\/\n.qch-fan-srcs{position:relative;z-index:1;display:flex;flex-direction:column;align-items:center;gap:.9rem;justify-self:center}\n.qch-fan-src{position:relative;z-index:1;display:flex;flex-direction:column;align-items:center;gap:.7rem;text-align:center;\n  padding:.6rem;justify-self:center;max-width:230px}\n.qch-fan-ghost{position:relative;z-index:1;display:flex;flex-direction:column;align-items:center;gap:.2rem;text-align:center;\n  width:190px;padding:.7rem .8rem .75rem;border-radius:12px;border:1px dashed var(--border-2);color:var(--ink-2);text-decoration:none;\n  background:oklch(100% 0 0 \/ .025);transition:border-color .2s var(--ease),background .2s var(--ease),color .2s var(--ease)}\n.qch-fan-ghost:hover{border-color:var(--emerald-line);background:oklch(100% 0 0 \/ .05);color:var(--ink)}\n.qch-fan-ghost .plus{width:26px;height:26px;border-radius:50%;border:1px dashed var(--border-2);display:grid;place-items:center;\n  font-size:.7rem;color:var(--ink-3);margin-bottom:.25rem}\n.qch-fan-ghost:hover .plus{color:var(--ico);border-color:var(--emerald-line)}\n.qch-fan-ghost b{font-size:.86rem;font-weight:600;line-height:1.2}\n.qch-fan-ghost small{font-family:var(--font-m);font-size:.62rem;letter-spacing:.06em;text-transform:uppercase;color:var(--ink-3);line-height:1.5}\n.qch-fan-ghost small em{font-style:normal;color:var(--ico)}\n.qch-fan-lines path.is-ghost{stroke-dasharray:3 6;stroke:oklch(100% 0 0 \/ .22)}\n#qspx-connector-hub .qch-fan-src .qch-mark{width:64px;height:64px;border-radius:16px}\n#qspx-connector-hub .qch-fan-src .qch-mark img{width:36px;height:36px}\n.qch-fan-src b{font-family:var(--font-d);font-weight:700;font-size:1.05rem;letter-spacing:-.01em;line-height:1.25}\n.qch-fan-stack{display:grid;grid-template-columns:repeat(3,1fr);gap:.3rem;align-items:end;width:150px}\n.qch-fan-stack .wb{position:relative;height:40px;border-radius:5px;background:oklch(100% 0 0 \/ .05);border:1px solid var(--border-2);overflow:hidden}\n.qch-fan-stack .wb::before{content:\"\";position:absolute;inset:0 0 auto 0;height:7px;background:var(--c1)}\n.qch-fan-stack .wb::after{content:\"\";position:absolute;left:5px;right:5px;top:13px;height:20px;\n  background:repeating-linear-gradient(to bottom,oklch(100% 0 0 \/ .18) 0 1px,transparent 1px 5px)}\n.qch-fan-stack .wb.more{display:grid;place-items:center;font-family:var(--font-m);font-size:.66rem;color:var(--ink-3);border-style:dashed}\n.qch-fan-stack .wb.more::before,.qch-fan-stack .wb.more::after{display:none}\n.qch-fan-table{position:relative;width:150px;height:52px;border-radius:6px;background:oklch(100% 0 0 \/ .05);border:1px solid var(--border-2);overflow:hidden}\n.qch-fan-table::before{content:\"\";position:absolute;inset:0 0 auto 0;height:10px;background:var(--c1)}\n.qch-fan-table::after{content:\"\";position:absolute;left:6px;right:6px;top:16px;bottom:5px;\n  background:repeating-linear-gradient(to bottom,oklch(100% 0 0 \/ .18) 0 1px,transparent 1px 8px),\n             repeating-linear-gradient(to right,transparent 0 46px,oklch(100% 0 0 \/ .14) 46px 47px)}\n.qch-fan-src small{font-family:var(--font-m);font-size:.68rem;letter-spacing:.06em;text-transform:uppercase;color:var(--ink-3);line-height:1.5}\n.qch-fan-src small em{font-style:normal;color:var(--ico)}\n\n\/* Agent node: the three claims the old counters row made, plus the platforms. *\/\n.qch-fan-agent{position:relative;z-index:1;display:flex;flex-direction:column;align-items:center;gap:.35rem;text-align:center;\n  padding:.85rem .9rem;border-radius:14px;background:var(--bg-900);border:1px solid var(--emerald-line);\n  box-shadow:0 0 0 6px oklch(64% 0.16 158 \/ .07),0 18px 30px -18px rgba(2,8,23,.9)}\n.qch-fan-agent>i{font-size:1.15rem;color:var(--ico)}\n.qch-fan-agent b{font-size:.9rem;font-weight:700}\n.qch-fan-agent ul{list-style:none;margin:.15rem 0 0;padding:0;display:flex;flex-direction:column;gap:.12rem}\n.qch-fan-agent li{font-family:var(--font-m);font-size:.64rem;letter-spacing:.05em;text-transform:uppercase;color:var(--ink-3);white-space:nowrap}\n.qch-fan-agent li b{font-size:.64rem;color:var(--ico);font-weight:700}\n.qch-fan-os{display:flex;align-items:center;gap:.55rem;margin:.55rem 0 0;padding-top:.55rem;border-top:1px solid var(--border);width:100%;justify-content:center}\n.qch-fan-os span{font-family:var(--font-m);font-size:.6rem;letter-spacing:.08em;text-transform:uppercase;color:var(--ink-3)}\n.qch-fan-os i{font-size:1.05rem;filter:drop-shadow(0 2px 4px rgba(2,8,23,.6))}\n.qch-fan-os .os-win{color:#4cc2ff}.qch-fan-os .os-mac{color:#e8ecf3}.qch-fan-os .os-lin{color:#f7c948}\n\n\/* Destination nodes, grouped by audience. Each is a link to its list row. *\/\n.qch-fan-dests{position:relative;z-index:1;list-style:none;margin:0;padding:0;display:flex;flex-direction:column;gap:.42rem}\n.qch-fan-grp{font-family:var(--font-m);font-size:.6rem;letter-spacing:.12em;text-transform:uppercase;color:var(--ico);padding:.45rem 0 0 .7rem;line-height:1}\n.qch-fan-grp:first-child{padding-top:0}\n.qch-fan-dest{display:flex;align-items:center;gap:.7rem;padding:.42rem .8rem .42rem .5rem;border-radius:999px;\n  background:oklch(100% 0 0 \/ .035);border:1px solid var(--border);color:var(--ink);text-decoration:none;\n  transition:transform .22s var(--ease),border-color .22s var(--ease),background .22s var(--ease)}\n.qch-fan-dest:hover,.qch-fan-dest.is-hot{transform:translateX(6px);border-color:var(--emerald-line);\n  background:color-mix(in oklab,var(--emerald) 8%,oklch(27% 0.035 258))}\n.qch-fan-dest.is-planned{opacity:.5}\n.qch-fan-dest.is-planned:hover{transform:none;border-color:var(--border);background:oklch(100% 0 0 \/ .035)}\n#qspx-connector-hub .qch-fan-dest img{width:30px;height:30px;flex:0 0 auto;object-fit:contain;filter:drop-shadow(0 4px 6px rgba(2,8,23,.5))}\n#qspx-connector-hub .qch-fan-dest img.nova,#qspx-connector-hub .qch-fan-row .ri.nova{border-radius:50%;box-shadow:0 0 0 2px var(--emerald-line)}\n.qch-fan-dest .ph{width:30px;height:30px;flex:0 0 auto;border-radius:8px;border:1px dashed var(--border-2);display:grid;place-items:center;color:var(--ink-3);font-size:.8rem}\n.qch-fan-dest h3{margin:0;font-size:.98rem;font-weight:600;line-height:1.2;letter-spacing:-.005em}\n.qch-fan-dest h3 span{display:block;font-family:var(--font-m);font-weight:400;font-size:.62rem;letter-spacing:.06em;text-transform:uppercase;color:var(--ink-3);margin-top:.12rem}\n.qch-fan-dest>i{margin-left:auto;font-size:.7rem;color:var(--ink-3);transition:transform .2s var(--ease),color .2s var(--ease)}\n.qch-fan-dest:hover>i{transform:translateX(3px);color:var(--ico)}\n\n\/* Under the diagram: the capsule (AI extraction unit, unchanged) and the\n   family \/ wire-protocol note rendered as chips instead of a prose footer. *\/\n.qch-fan-text{display:grid;grid-template-columns:minmax(0,1.5fr) minmax(0,1fr);gap:clamp(1rem,3vw,2.5rem);align-items:start;\n  margin-top:clamp(1.2rem,2.5vw,1.8rem);padding-inline:.4rem}\n#qspx-connector-hub .qch-fan-text .qch-capsule{font-size:1rem;margin:0;line-height:1.7;color:var(--ink-2);text-wrap:pretty}\n.qch-fan-fam{display:flex;flex-wrap:wrap;gap:.4rem;align-items:center;margin:0}\n.qch-fan-fam .lbl{font-family:var(--font-m);font-size:.64rem;letter-spacing:.08em;text-transform:uppercase;color:var(--ink-3);margin-right:.2rem;flex-basis:100%;line-height:1.5}\n.qch-fan-fam .lbl i{color:var(--emerald-bright);margin-right:.3rem}\n.qch-fan-fam .lbl a{color:var(--emerald-bright);border-bottom:1px solid var(--emerald-line)}\n.qch-fan-fam .chip{font-size:.8rem;color:var(--ink-2);text-decoration:none;padding:.22rem .6rem;border-radius:999px;\n  border:1px solid var(--border);background:oklch(100% 0 0 \/ .03);transition:border-color .18s var(--ease),color .18s var(--ease)}\n.qch-fan-fam a.chip:hover{border-color:var(--emerald-line);color:var(--ink)}\n.qch-fan-fam .chip.is-self{color:var(--ico);border-color:var(--emerald-line);background:var(--emerald-soft)}\n#qspx-connector-hub .qch-fan-text .qch-answer-note{margin-top:0;padding-top:0;border-top:0}\n\n\/* The list: one solid panel (the page grid made hairline rows hard to read),\n   fixed columns so every heading, description and link starts on the same x. *\/\n.qch-fan-list{list-style:none;margin:clamp(1.6rem,3vw,2.4rem) 0 0;padding:.3rem clamp(1rem,2.5vw,1.6rem);\n  background:oklch(24% 0.035 258 \/ .92);border:1px solid var(--border-2);border-radius:20px;\n  box-shadow:0 30px 60px -30px rgba(2,8,23,.7);backdrop-filter:blur(8px);-webkit-backdrop-filter:blur(8px)}\n.qch-fan-row{display:grid;grid-template-columns:34px 300px minmax(0,1fr) 220px;gap:1.1rem;align-items:start;\n  padding:1rem .5rem;border-bottom:1px solid var(--border);transition:background .18s var(--ease)}\n.qch-fan-row:last-child{border-bottom:0}\n.qch-fan-row:hover,.qch-fan-row.is-hot{background:oklch(100% 0 0 \/ .035)}\n.qch-fan-row.is-planned{opacity:.55}\n#qspx-connector-hub .qch-fan-row .ri{width:30px;height:30px;margin-top:.1rem;object-fit:contain;filter:drop-shadow(0 4px 6px rgba(2,8,23,.5))}\n.qch-fan-row .ph{width:30px;height:30px;border-radius:8px;border:1px dashed var(--border-2);display:grid;place-items:center;color:var(--ink-3);font-size:.8rem}\n.qch-fan-row h3{margin:0;font-size:1.02rem;font-weight:600;line-height:1.3;color:var(--ink)}\n.qch-fan-row h3 a{color:inherit;text-decoration:none}.qch-fan-row h3 a:hover{color:var(--emerald-bright)}\n.qch-fan-row .rl{display:block;line-height:0;margin-top:.1rem}.qch-fan-row .rl .ri{margin-top:0}\n.qch-fan-row h3 span{display:block;font-family:var(--font-m);font-weight:400;font-size:.64rem;letter-spacing:.06em;text-transform:uppercase;color:var(--ink-3);margin-top:.2rem}\n.qch-fan-row p{margin:0;color:var(--ink-2);font-size:.95rem;line-height:1.55;text-wrap:pretty}\n.qch-fan-row .qspx-link{white-space:nowrap;font-size:.86rem;margin-top:.15rem;justify-self:end;text-align:right}\n.qch-fan-row .qspx-link.is-guide{color:var(--emerald-bright)}\n.qch-fan-row .qch-via{justify-self:end;text-align:right;margin-top:.25rem}\n.qch-fan-group{grid-column:1\/-1;padding:1.1rem .5rem .35rem;font-family:var(--font-m);font-size:.66rem;letter-spacing:.12em;text-transform:uppercase;color:var(--ico);border-bottom:1px solid var(--border)}\n.qch-via{font-family:var(--font-m);font-size:.66rem;color:var(--ink-3);line-height:1.4}\n\n\/* How it works -- canonical .qspx-step, count driven by the catalog's `how`. *\/\n.qspx-how{background:var(--bg-900);border-block:1px solid var(--border)}\n.qch-steps{display:grid;grid-template-columns:repeat(3,minmax(0,1fr));gap:1.1rem;\n  max-width:var(--maxw);margin-inline:auto;padding-inline:var(--pad)}\n.qspx-step{background:var(--glass-2);border:1px solid var(--border);border-radius:16px;padding:1.5rem;\n  display:flex;flex-direction:column;gap:.5rem;min-width:0}\n.qspx-step .n{display:flex;flex-direction:column;align-items:flex-start;gap:.35rem;margin-bottom:.2rem}\n.qspx-step .n b{font-family:var(--font-m);font-weight:700;font-size:1.95rem;line-height:1;color:var(--ico)}\n.qspx-step .n em{display:block;width:28px;height:3px;border-radius:2px;background:var(--emerald);font-style:normal}\n.qspx-step p{color:var(--ink-2);font-size:.94rem;line-height:1.55}\n\n\/* Feature deep-dive -- the connector's `sections` as a two-column card grid.\n   For the File Set family this is the product story (refusal behaviour,\n   inventory tables, layout pinning), so it earns real cards, not prose. The\n   code block reads as a mini editor: mono, near-black well, emerald spine --\n   same voice as the qch-spec labels. *\/\n#qspx-connector-hub .qch-feats{max-width:var(--maxw);margin-inline:auto;padding-inline:var(--pad);\n  display:grid;grid-template-columns:repeat(2,minmax(0,1fr));gap:1.1rem}\n#qspx-connector-hub .qch-feat{background:linear-gradient(180deg,var(--glass),var(--glass-2));\n  border:1px solid var(--border);border-radius:16px;padding:1.35rem 1.4rem;\n  display:flex;flex-direction:column;gap:.8rem}\n#qspx-connector-hub .qch-feat h3{font-size:1.05rem;letter-spacing:-0.01em}\n#qspx-connector-hub .qch-feat p{color:var(--ink-2);font-size:.92rem;line-height:1.66;text-wrap:pretty}\n#qspx-connector-hub .qch-feat ul{display:grid;gap:.55rem}\n#qspx-connector-hub .qch-feat li{display:flex;gap:.6rem;align-items:flex-start;\n  color:var(--ink-2);font-size:.9rem;line-height:1.6}\n#qspx-connector-hub .qch-feat li i{color:var(--emerald-bright);font-size:.72rem;margin-top:.34rem;flex-shrink:0}\n#qspx-connector-hub .qch-feat li b{color:var(--ink);font-weight:600}\n#qspx-connector-hub .qch-code{margin:0;margin-top:auto;background:oklch(17% 0.04 264 \/ .75);\n  border:1px solid var(--border);border-radius:10px;\n  padding:.85rem 1rem;overflow-x:auto}\n#qspx-connector-hub .qch-code code{font-family:var(--font-m);font-size:.78rem;line-height:1.62;\n  color:var(--ico);background:none;padding:0;white-space:pre}\n\/* An odd card count strands an orphan in a 2-col grid; let the last one own\n   the full row instead. :has() guards against a code block stretching to an\n   unreadable measure -- a wide card is fine for prose, wrong for SQL. *\/\n#qspx-connector-hub .qch-feat:last-child:nth-child(odd):not(:has(.qch-code)){grid-column:1\/-1}\n\n\/* Family band -- the FILES_COMMON guarantees, identical on every File Set hub.\n   Deliberately NOT a box: the connector's own facts get cards, the family's\n   get a flat footer register under a hairline -- the register change IS the\n   hierarchy, no chrome needed. (An earlier draft boxed it with an emerald\n   left rail; a full-height colored left border is the stock admonition-callout\n   look, and a third box competed with the cards it is subordinate to.) The\n   wrapping .qspx-wrap aligns its edges with the card grid, which carries the\n   same maxw+pad pair itself. *\/\n#qspx-connector-hub .qch-famband{margin-top:2.2rem;padding-top:1.6rem;\n  border-top:1px solid var(--border)}\n#qspx-connector-hub .qch-famband-hd{font-family:var(--font-m);font-size:.62rem;font-weight:500;\n  letter-spacing:.16em;text-transform:uppercase;color:var(--ico);\n  display:flex;align-items:center;gap:.55rem;margin-bottom:1rem}\n#qspx-connector-hub .qch-famband-hd i{font-size:.78rem;color:var(--emerald-bright)}\n#qspx-connector-hub .qch-famband-cols{display:grid;grid-template-columns:repeat(2,minmax(0,1fr));\n  gap:1.5rem 2.2rem}\n#qspx-connector-hub .qch-famband-col h3{font-size:.92rem;letter-spacing:-0.01em;\n  color:var(--ink-2);margin-bottom:.6rem}\n#qspx-connector-hub .qch-famband-col p{color:var(--ink-3);font-size:.88rem;line-height:1.62;text-wrap:pretty}\n#qspx-connector-hub .qch-famband-col ul{display:grid;gap:.5rem}\n#qspx-connector-hub .qch-famband-col li{display:flex;gap:.6rem;align-items:flex-start;\n  color:var(--ink-3);font-size:.87rem;line-height:1.58}\n#qspx-connector-hub .qch-famband-col li i{color:var(--emerald-2);font-size:.68rem;margin-top:.32rem;flex-shrink:0}\n#qspx-connector-hub .qch-famband-col li b{color:var(--ink-2);font-weight:600}\n\n\/* Cross-source SQL -- ONE panel, split source-list | statement. The point of the\n   feature is that separate sources CONVERGE on a single query, so a card per\n   source would state the opposite; the sources are rows inside the same box the\n   statement lives in. Mono micro-labels (\"3 connections\", \"One statement\") carry\n   the register instead of chrome -- no accent rails anywhere (user call\n   2026-08-30). The statement well reuses .qch-code so SQL looks identical\n   wherever it appears on the page. *\/\n#qspx-connector-hub .qch-fed{max-width:var(--maxw);margin-inline:auto;padding-inline:var(--pad)}\n#qspx-connector-hub .qch-fed-panel{display:grid;\n  grid-template-columns:minmax(0,.72fr) minmax(0,1.28fr);gap:1.6rem;align-items:center;\n  background:linear-gradient(180deg,var(--glass),var(--glass-2));\n  border:1px solid var(--border);border-radius:16px;padding:1.4rem 1.5rem}\n#qspx-connector-hub .qch-fed-lbl{font-family:var(--font-m);font-size:.6rem;font-weight:500;\n  letter-spacing:.16em;text-transform:uppercase;color:var(--ico);margin-bottom:.85rem}\n#qspx-connector-hub .qch-fed-src{display:grid;gap:.1rem}\n\/* Rows read as a stack that belongs together: hairline between, none trailing. *\/\n#qspx-connector-hub .qch-fed-row{display:flex;align-items:center;gap:.7rem;padding:.62rem 0;\n  border-bottom:1px solid var(--border)}\n#qspx-connector-hub .qch-fed-row:last-child{border-bottom:0;padding-bottom:0}\n\n\/* Reference annotation, mirroring \/features\/federated-queries\/ deliberately:\n   same three accents, same numbered token, so a reader arriving from that page\n   recognises the notation instead of relearning it. If that palette changes,\n   change it in both places -- the feature page carries its CSS inline, so there\n   is no shared stylesheet to hang it on.\n   NOTE these accents are the ONE sanctioned use of a colored left border on a\n   hub page, and only on the number badge's own background, not as a full-height\n   rail on a panel -- that device stays retired (user call 2026-08-30). *\/\n#qspx-connector-hub .qch-fed-a1{--acc:oklch(80% 0.12 200);--accSoft:oklch(80% 0.12 200 \/ .15)}\n#qspx-connector-hub .qch-fed-a2{--acc:oklch(74% 0.16 158);--accSoft:oklch(74% 0.16 158 \/ .15)}\n#qspx-connector-hub .qch-fed-a3{--acc:oklch(83% 0.15 85);--accSoft:oklch(83% 0.15 85 \/ .15)}\n\/* The badge is the tie between a tile and its reference; it carries the tile's\n   accent as a solid fill so the pairing survives a glance. *\/\n#qspx-connector-hub .qch-fed-num{width:18px;height:18px;flex-shrink:0;display:grid;\n  place-items:center;border-radius:5px;font-family:var(--font-m);font-size:.64rem;\n  font-weight:700;color:oklch(18% 0.03 260);background:var(--acc)}\n#qspx-connector-hub .qch-fed-sql .qch-fed-tok{color:var(--acc);background:var(--accSoft);\n  border-bottom:2px solid var(--acc);border-radius:4px;padding:1px 3px}\n#qspx-connector-hub .qch-fed-sql .qch-fed-tok b{font-weight:700;color:var(--acc)}\n#qspx-connector-hub .qch-fed-tok-n{font-size:.72em;font-weight:700;vertical-align:.35em;\n  margin-left:.25em;opacity:.9}\n\/* Keyword + comment colours match the feature page's SQL block so the two\n   statements read as the same language, not two house styles. *\/\n#qspx-connector-hub .qch-fed-sql .kw{color:var(--emerald-bright)}\n#qspx-connector-hub .qch-fed-sql .cm{color:var(--ink-3)}\n\/* The tokens add ~2px of padding and a 2px underline per line; without a little\n   more leading the underlines crowd the row below. *\/\n#qspx-connector-hub .qch-fed-sql{line-height:1.95}\n#qspx-connector-hub .qch-fed-ic{width:22px;height:22px;flex-shrink:0;display:grid;place-items:center}\n#qspx-connector-hub .qch-fed-ic img{width:22px;height:22px;object-fit:contain}\n#qspx-connector-hub .qch-fed-nm{display:grid;gap:.1rem;min-width:0}\n#qspx-connector-hub .qch-fed-nm b{color:var(--ink);font-size:.9rem;font-weight:600;letter-spacing:-0.01em}\n#qspx-connector-hub .qch-fed-nm i{color:var(--ink-3);font-size:.74rem;font-style:normal;\n  font-family:var(--font-m);letter-spacing:.02em}\n#qspx-connector-hub .qch-fed-foot{max-width:78ch;margin-top:1.1rem;\n  color:var(--ink-3);font-size:.86rem;line-height:1.65;text-wrap:pretty}\n#qspx-connector-hub .qch-fed-foot a{color:var(--emerald-bright);border-bottom:1px solid var(--emerald-line);\n  white-space:nowrap}\n\/* Below ~900px the statement cannot hold its measure beside the list, and SQL is\n   the thing worth the full width -- so stack, list first. *\/\n@media (max-width:900px){\n  #qspx-connector-hub .qch-fed-panel{grid-template-columns:minmax(0,1fr);gap:1.3rem}\n}\n\n\/* Connection details. *\/\n.qch-conn{background:var(--bg-950);border-block:1px solid var(--border)}\n\/* ID-scoped on purpose: the base resets above are `#qspx-connector-hub ul` and\n   `#qspx-connector-hub p { margin:0 }`, which outrank a bare class and would\n   silently kill the `margin-inline:auto` that centres these two blocks. *\/\n#qspx-connector-hub .qch-facts{max-width:52rem;margin-inline:auto;padding-inline:var(--pad);display:grid;gap:.7rem}\n.qch-facts li{display:flex;gap:.7rem;align-items:flex-start;color:var(--ink-2);font-size:.98rem;line-height:1.55}\n.qch-facts i{color:var(--emerald-bright);font-size:.8rem;margin-top:.42rem;flex-shrink:0}\n\/* Spec rows -- the port\/driver\/TLS\/host table. Two columns on desktop with the\n   label in the mono voice, collapsing to stacked label-over-value on mobile so\n   a long hostname never has to share a line with its own name. Values wrap\n   with `anywhere` because the pooled host is one unbroken token. *\/\n#qspx-connector-hub .qch-spec{max-width:52rem;margin-inline:auto;padding-inline:var(--pad);\n  display:grid;gap:0;border:1px solid var(--border);border-radius:14px;\n  background:var(--glass);overflow:hidden;padding-block:0}\n.qch-spec>div{display:grid;grid-template-columns:minmax(9rem,11rem) 1fr;gap:1rem;\n  padding:.78rem 1.15rem;border-top:1px solid var(--border)}\n.qch-spec>div:first-child{border-top:0}\n.qch-spec dt{font-family:var(--font-m);font-size:.7rem;letter-spacing:.06em;text-transform:uppercase;\n  color:var(--ink-3);padding-top:.16rem}\n.qch-spec dd{margin:0;color:var(--ink-2);font-size:.95rem;line-height:1.55;overflow-wrap:anywhere}\n\n\/* Prose that will not fit a spec row: the pooler adaptation, scale-to-zero,\n   the grant. This is the part that makes the page worth indexing. *\/\n#qspx-connector-hub .qch-notes{max-width:52rem;margin:1.15rem auto 0;padding-inline:var(--pad);\n  display:grid;gap:.85rem}\n#qspx-connector-hub .qch-notes p{color:var(--ink-2);font-size:.95rem;line-height:1.68;margin:0}\n\n\/* Amber, not red: an unwritten section is a backlog item, not a failure. *\/\n.qch-todo{max-width:52rem;margin-inline:auto;background:var(--amber);border:1px solid var(--amber-line);\n  border-radius:14px;padding:1.1rem 1.3rem;display:flex;gap:.85rem;align-items:flex-start;\n  color:var(--ink-2);font-size:.95rem;line-height:1.55}\n.qch-todo i{color:var(--star);margin-top:.25rem}\n.qch-todo b{color:var(--ink)}\n#qspx-connector-hub .qch-vendor{max-width:52rem;margin:1.2rem auto 0;padding-inline:var(--pad);\n  font-family:var(--font-m);font-size:.74rem;color:var(--ink-3)}\n.qch-vendor a{color:var(--ink-2);border-bottom:1px solid var(--border-2)}\n.qch-vendor a:hover{color:var(--ico);border-color:var(--emerald-line)}\n\n\/* Sibling chips -- the .qspx-chip pop-out tile from the central v4 kit. *\/\n.qch-sibs{display:flex;flex-wrap:wrap;justify-content:center;gap:1rem .7rem;padding-top:.7rem;\n  max-width:var(--maxw);margin-inline:auto;padding-inline:var(--pad)}\n.qspx-chip{position:relative;isolation:isolate;display:inline-flex;align-items:center;gap:.6rem;\n  padding:.6rem 1.15rem .6rem .7rem;margin-top:.35rem;font-family:var(--font-d);font-weight:600;font-size:.92rem;\n  line-height:1;color:var(--ink-2);white-space:nowrap;background:linear-gradient(180deg,var(--glass),var(--glass-2));\n  border:1px solid var(--border-2);border-radius:999px;overflow:visible;\n  transition:transform .2s var(--ease),border-color .2s var(--ease),color .2s var(--ease),box-shadow .2s var(--ease),background .2s var(--ease)}\n.qspx-chip-ic{flex-shrink:0;width:34px;height:34px;margin:-14px 0 -6px -6px;display:grid;place-items:center;\n  border-radius:11px;background:linear-gradient(150deg,oklch(31% 0.038 260),oklch(23% 0.042 264));\n  border:1px solid var(--border-2);\n  box-shadow:0 9px 18px -6px rgba(2,8,23,.75),inset 0 1px 0 oklch(100% 0 0 \/ .10);\n  transition:transform .2s var(--ease),box-shadow .2s var(--ease),border-color .2s var(--ease)}\n#qspx-connector-hub .qspx-chip-ic img{width:20px;height:20px;object-fit:contain}\n.qspx-chip:hover{transform:translateY(-2px);color:var(--ink);border-color:var(--emerald-line);\n  background:linear-gradient(180deg,oklch(64% 0.16 158 \/ .13),var(--glass-2));\n  box-shadow:0 18px 36px -18px oklch(64% 0.16 158 \/ .6)}\n.qspx-chip:hover .qspx-chip-ic{transform:translateY(-3px) rotate(-4deg);border-color:var(--emerald-bright)}\n\n\/* FAQ. *\/\n.qch-faq{max-width:52rem;margin-inline:auto;padding-inline:var(--pad)}\n.qch-faq details{border-bottom:1px solid var(--border);padding:.15rem 0}\n.qch-faq summary{cursor:pointer;list-style:none;display:flex;gap:.8rem;align-items:flex-start;\n  padding:1.05rem .2rem;font-family:var(--font-d);font-weight:600;font-size:1rem;color:var(--ink)}\n.qch-faq summary::-webkit-details-marker{display:none}\n.qch-faq summary i{color:var(--emerald-bright);font-size:.78rem;margin-top:.35rem;flex-shrink:0;\n  transition:transform .18s var(--ease)}\n.qch-faq details[open] summary i{transform:rotate(90deg)}\n.qch-faq p{padding:0 .2rem 1.15rem 1.78rem;color:var(--ink-2);font-size:.95rem;line-height:1.65}\n\n\/* Closing CTA -- canonical v4. *\/\n.qspx-cta{padding-block:clamp(3.5rem,7vw,5.5rem)}\n.qspx-cta-card{position:relative;overflow:hidden;max-width:var(--maxw);margin-inline:auto;background:var(--glass);\n  backdrop-filter:blur(16px);-webkit-backdrop-filter:blur(16px);border:1px solid var(--emerald-line);border-radius:22px;\n  padding:clamp(2rem,4.5vw,3.2rem);display:flex;flex-direction:column;align-items:center;text-align:center;gap:1rem}\n.qspx-cta-card::before{content:\"\";position:absolute;inset:0;pointer-events:none;\n  background:radial-gradient(620px 300px at 50% 0%,oklch(64% 0.16 158 \/ .16) 0%,transparent 70%)}\n.qspx-cta-card>*{position:relative;z-index:1}\n.qspx-reassure{font-family:var(--font-m);font-size:.78rem;letter-spacing:.03em;color:var(--ink-3);\n  display:inline-flex;align-items:center;gap:.5rem;flex-wrap:wrap;justify-content:center}\n.qspx-reassure i{color:var(--emerald-bright);font-size:.8rem}\n\n@media (max-width:900px){\n  .qch-dests,.qch-steps{grid-template-columns:repeat(2,minmax(0,1fr))}\n}\n@media (max-width:820px){\n  #qspx-connector-hub .qch-feats{grid-template-columns:minmax(0,1fr)}\n  #qspx-connector-hub .qch-famband-cols{grid-template-columns:minmax(0,1fr)}\n}\n@media (max-width:640px){\n  .qch-steps{grid-template-columns:minmax(0,1fr)}\n  .qch-crumbs{justify-content:flex-start}\n  .qspx-btn{width:100%}\n  .qspx-ctas{width:100%}\n  \/* A hostname plus its label will not share 375px. Stack them. *\/\n  .qch-spec>div{grid-template-columns:minmax(0,1fr);gap:.28rem;padding:.72rem 1rem}\n  .qch-spec dt{padding-top:0}\n}\n@media (max-width:560px){\n  .qspx-chip{width:100%;justify-content:flex-start}\n}\n@media (prefers-reduced-motion:no-preference){\n  html{scroll-behavior:smooth}\n}\n@media (prefers-reduced-motion:reduce){\n  .qch-fan-dest,.qch-fan-dest>i,.qch-fan-row,.qch-fan-lines path,\n  .qspx-btn,.qspx-chip,.qspx-chip-ic,.qch-faq summary i{transition:none}\n  .qch-fan-dest:hover,.qch-fan-dest:hover>i,.qspx-chip:hover{transform:none}\n  \/* The flowing dash is motion too. *\/\n  .qch-fan-lines path.is-flow{animation:none;stroke-dasharray:none}\n}\n\/* Fan-out on narrow screens: nodes stack along a spine, lines are hidden, the\n   list collapses to icon + text. *\/\n@media (max-width:860px){\n  .qch-fan-diagram{grid-template-columns:1fr;gap:1.1rem;padding:1.1rem}\n  .qch-fan-lines{display:none}\n  \/* The flow, stacked: one dashed spine down the centre from the source to the\n     last destination. Every node gets an opaque ground so the spine runs BEHIND\n     it and shows only in the gaps -- that is what turns a pile into a sequence. *\/\n  .qch-fan-diagram::after{content:\"\";position:absolute;left:50%;top:1.6rem;bottom:1.6rem;width:2px;margin-left:-1px;z-index:0;pointer-events:none;\n    background:repeating-linear-gradient(to bottom,var(--emerald-line) 0 7px,transparent 7px 13px)}\n  \/* Opaque stand-in for the desktop glass (which is translucent and would let\n     the spine show through). Only the agent keeps --bg-900, so it stays the\n     dark focal node exactly as on desktop. *\/\n  .qch-fan-srcs{width:100%;gap:1.1rem}\n  .qch-fan-src{max-width:340px;width:100%;padding:.9rem;border-radius:14px;background:oklch(32% 0.032 257);border:1px solid var(--border-2)}\n  .qch-fan-ghost{width:100%;max-width:340px;background:oklch(32% 0.032 257)}\n  .qch-fan-agent{margin-inline:auto;width:max-content;max-width:100%}\n  .qch-fan-dests{border-left:0;margin-left:0;padding-left:0;gap:.55rem}\n  .qch-fan-grp{width:max-content;max-width:100%;margin:.2rem auto 0;padding:.3rem .7rem;border-radius:999px;text-align:center;\n    background:oklch(30% 0.032 257);border:1px solid var(--border)}\n  .qch-fan-grp:first-child{margin-top:.2rem;padding:.3rem .7rem}\n  .qch-fan-dest{background:oklch(32% 0.032 257)}\n  .qch-fan-dest:hover,.qch-fan-dest.is-hot{transform:none}\n  .qch-fan-text{grid-template-columns:1fr}\n  .qch-fan-row{grid-template-columns:30px minmax(0,1fr);gap:.3rem .8rem}\n  .qch-fan-row p,.qch-fan-row .qspx-link,.qch-fan-row .qch-via{grid-column:2}\n  .qch-fan-row .qspx-link,.qch-fan-row .qch-via{justify-self:start;text-align:left}\n}\n<\/style><div id=\"qspx-connector-hub\" data-qs=\"connector-hub-v4\"\n     style=\"--c1:#312E81;--c2:#E879F9\">\n\n  <nav class=\"qch-crumbs\" aria-label=\"Breadcrumb\">\n    <a href=\"https:\/\/querystreams.com\/\">Query Streams<\/a>\n    <i class=\"fa-solid fa-chevron-right\" aria-hidden=\"true\"><\/i>\n    <a href=\"https:\/\/querystreams.com\/database-integrations\/\">Database Integrations<\/a>\n    <i class=\"fa-solid fa-chevron-right\" aria-hidden=\"true\"><\/i>\n    <span aria-current=\"page\">Multi-record CSV<\/span>\n  <\/nav>\n\n  <header class=\"qspx-hero\">\n    <div class=\"qspx-hero-inner\">\n\n      <div class=\"qch-mark\">\n        <img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/my.querystreams.com\/data-sources\/icon-recordtype-csv.svg\" width=\"46\" height=\"46\"\n             alt=\"Multi-record CSV logo\" loading=\"eager\" fetchpriority=\"high\">\n      <\/div>\n\n      <p class=\"qch-kindrow\">\n        <span class=\"qspx-eyebrow\">Tagged records<\/span>\n                          <span class=\"qch-chip qch-chip-new\">New<\/span>\n              <\/p>\n\n      <h1 class=\"qspx-h1\">Query a <span class=\"qspx-hl\">Multi-record CSV<\/span> with SQL \u2014 in Excel, Google Sheets, AI and REST<\/h1>\n\n      <p class=\"qspx-lede\">For CSV files that hold several kinds of record at once \u2014 a tag on each line says what that line is. Machine and interchange exports look like nonsense to normal CSV tools; this turns them into one clean table per record type.<\/p>\n\n      <div class=\"qspx-ctas\">\n        <a class=\"qspx-btn qspx-btn-primary\" href=\"https:\/\/my.querystreams.com\">\n          Start free <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i>\n        <\/a>\n        <a class=\"qspx-btn qspx-btn-ghost\" href=\"#destinations\">\n          <i class=\"fa-solid fa-diagram-project\" aria-hidden=\"true\"><\/i> 13 destinations\n        <\/a>\n                  <a class=\"qspx-btn qspx-btn-ghost\" href=\"https:\/\/querystreams.com\/docs\/query-multi-record-csv-files-with-sql\/\">\n            <i class=\"fa-solid fa-book-open\" aria-hidden=\"true\"><\/i> Multi-record CSV guide\n          <\/a>\n              <\/div>\n\n      \n    <\/div>\n  <\/header>\n\n    <section class=\"qspx-section qch-fan\" id=\"destinations\">\n    <div class=\"qspx-wrap\">\n    <div class=\"qspx-shead\">\n      <p class=\"qspx-eyebrow\">One connection, every surface<\/p>\n      <h2 class=\"qspx-h2\">Where your Multi-record CSV data can go<\/h2>\n    <\/div>\n\n    <div class=\"qch-fan-diagram\" data-qch-fan>\n      <svg class=\"qch-fan-lines\" aria-hidden=\"true\"><\/svg>\n\n      <div class=\"qch-fan-srcs\">\n        <div class=\"qch-fan-src\" data-fan-src>\n          <div class=\"qch-mark\"><img loading=\"lazy\" src=\"https:\/\/my.querystreams.com\/data-sources\/icon-recordtype-csv.svg\" width=\"36\" height=\"36\" alt=\"\" loading=\"lazy\" decoding=\"async\"><\/div>\n          <b>Multi-record CSV<\/b>\n                      <div class=\"qch-fan-stack\" aria-hidden=\"true\">\n              <span class=\"wb\"><\/span><span class=\"wb\"><\/span><span class=\"wb\"><\/span>\n              <span class=\"wb\"><\/span><span class=\"wb\"><\/span><span class=\"wb more\">+<\/span>\n            <\/div>\n                    <small><em>many files<\/em> \u2192 one live table each<\/small>\n        <\/div>\n                <a class=\"qch-fan-ghost\" data-fan-ghost href=\"#federated\">\n          <span class=\"plus\" aria-hidden=\"true\"><i class=\"fa-solid fa-plus\"><\/i><\/span>\n          <b>Federated queries<\/b>\n          <small>+ any other connector \u00b7 <em>one SQL<\/em> across sources \u00b7 every plan<\/small>\n        <\/a>\n      <\/div>\n\n      <div class=\"qch-fan-agent\" data-fan-agent>\n        <i class=\"fa-solid fa-shield-halved\" aria-hidden=\"true\"><\/i>\n        <b>Network Agent<\/b>\n        <ul>\n          <li><b>1<\/b> outbound connection<\/li>\n          <li><b>0<\/b> inbound ports<\/li>\n          <li>read-only \u00b7 files stay put<\/li>\n        <\/ul>\n        <p class=\"qch-fan-os\" aria-label=\"Runs on Windows, macOS and Linux\">\n          <span>runs on<\/span>\n          <i class=\"fa-brands fa-windows os-win\" title=\"Windows\" aria-hidden=\"true\"><\/i>\n          <i class=\"fa-brands fa-apple os-mac\" title=\"macOS\" aria-hidden=\"true\"><\/i>\n          <i class=\"fa-brands fa-linux os-lin\" title=\"Linux\" aria-hidden=\"true\"><\/i>\n        <\/p>\n      <\/div>\n\n      <ul class=\"qch-fan-dests\">\n                  <li class=\"qch-fan-grp\">For your team, vendors and partners<\/li>\n                      <li><a class=\"qch-fan-dest\" href=\"#d-excel\"\n                   data-rows=\"d-excel\">\n                              <img loading=\"lazy\" class=\"\" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-excel.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\">\n                            <h3>Excel <span>add-in \u00b7 refresh on demand<\/span><\/h3>\n              <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i>\n            <\/a><\/li>\n                      <li><a class=\"qch-fan-dest\" href=\"#d-sheets\"\n                   data-rows=\"d-sheets\">\n                              <img loading=\"lazy\" class=\"\" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-gsheets.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\">\n                            <h3>Google Sheets <span>add-on \u00b7 refresh on demand<\/span><\/h3>\n              <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i>\n            <\/a><\/li>\n                      <li><a class=\"qch-fan-dest\" href=\"#d-nova\"\n                   data-rows=\"d-nova\">\n                              <img loading=\"lazy\" class=\"nova\" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/03\/nova_128x128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\">\n                            <h3>Nova AI <span>ask in plain English \u00b7 text to SQL<\/span><\/h3>\n              <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i>\n            <\/a><\/li>\n                      <li><a class=\"qch-fan-dest\" href=\"#d-viewer\"\n                   data-rows=\"d-viewer\">\n                              <img loading=\"lazy\" class=\"\" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-sharing.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\">\n                            <h3>Data Viewer <span>share live results \u00b7 team, vendors, partners \u00b7 any device<\/span><\/h3>\n              <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i>\n            <\/a><\/li>\n                            <li class=\"qch-fan-grp\">For apps and systems<\/li>\n                      <li><a class=\"qch-fan-dest\" href=\"#d-restapi\"\n                   data-rows=\"d-restapi\">\n                              <img loading=\"lazy\" class=\"\" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-restapi.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\">\n                            <h3>REST API <span>JSON endpoint \u00b7 OpenAPI 3.1<\/span><\/h3>\n              <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i>\n            <\/a><\/li>\n                      <li><a class=\"qch-fan-dest\" href=\"#d-powerbi\"\n                   data-rows=\"d-powerbi\">\n                              <img loading=\"lazy\" class=\"\" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-powerbi.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\">\n                            <h3>Power BI <span>Power Query M<\/span><\/h3>\n              <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i>\n            <\/a><\/li>\n                      <li><a class=\"qch-fan-dest\" href=\"#d-sync\"\n                   data-rows=\"d-airtable d-baserow d-seatable d-smartsheet d-anvil\">\n                              <img loading=\"lazy\" class=\"\" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-automations.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\">\n                            <h3>Scheduled syncs <span>Google Sheets \u00b7 Airtable \u00b7 Baserow \u00b7 SeaTable \u00b7 Smartsheet \u00b7 Anvil<\/span><\/h3>\n              <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i>\n            <\/a><\/li>\n                            <li class=\"qch-fan-grp\">For AI tools<\/li>\n                      <li><a class=\"qch-fan-dest\" href=\"#d-mcp\"\n                   data-rows=\"d-mcp\">\n                              <img loading=\"lazy\" class=\"\" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-mcp.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\">\n                            <h3>AI assistants <span>Claude \u00b7 Cursor \u00b7 MCP server<\/span><\/h3>\n              <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i>\n            <\/a><\/li>\n                            <li class=\"qch-fan-grp\">Delivered to people<\/li>\n                      <li><a class=\"qch-fan-dest\" href=\"#d-alerts\"\n                   data-rows=\"d-alerts\">\n                              <img loading=\"lazy\" class=\"\" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-alerts.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\">\n                            <h3>Alerts &amp; reports <span>Slack \u00b7 Discord \u00b7 Email \u00b7 Webhook<\/span><\/h3>\n              <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i>\n            <\/a><\/li>\n                        <\/ul>\n    <\/div>\n\n        <div class=\"qch-fan-text\">\n      <p class=\"qch-capsule\">Query Streams turns a folder of tagged, multi-record CSV files into clean SQL tables readable from Microsoft Excel, Google Sheets, AI assistants over MCP, the REST API and Power BI. A tag on each line says what that line is, so the self-hosted agent routes it to the table for that record type \u2014 a file holding PNLHDR header lines and PNL1 detail lines becomes two proper tables instead of one unusable blob. Files stay on your machine; only query results leave the network.<\/p>\n              <p class=\"qch-fan-fam\">\n          <span class=\"lbl\"><i class=\"fa-solid fa-folder-tree\" aria-hidden=\"true\"><\/i>One of\n          9 File Set drivers on one folder engine \u2014 the inventory tables, change trail\n          and refusal rules under <a href=\"#features\">features<\/a> are shared by the family<\/span>\n          <span class=\"chip is-self\">Multi-record CSV<\/span>\n                                    <a class=\"chip\" href=\"https:\/\/querystreams.com\/database-integrations\/file-system\/\">File System<\/a>\n                                                <a class=\"chip\" href=\"https:\/\/querystreams.com\/database-integrations\/csv-folder\/\">CSV Folder<\/a>\n                                                <a class=\"chip\" href=\"https:\/\/querystreams.com\/database-integrations\/parquet-folder\/\">Parquet Folder<\/a>\n                                                <a class=\"chip\" href=\"https:\/\/querystreams.com\/database-integrations\/excel-folder\/\">Excel Folder<\/a>\n                                                <a class=\"chip\" href=\"https:\/\/querystreams.com\/database-integrations\/sqlite-folder\/\">SQLite Folder<\/a>\n                                                <a class=\"chip\" href=\"https:\/\/querystreams.com\/database-integrations\/jsonl-folder\/\">JSONL Folder<\/a>\n                                                <a class=\"chip\" href=\"https:\/\/querystreams.com\/database-integrations\/machine-logs\/\">Machine Logs<\/a>\n                                                <a class=\"chip\" href=\"https:\/\/querystreams.com\/database-integrations\/web-server-logs\/\">Web Server Logs<\/a>\n                              <\/p>\n          <\/div>\n\n        <ol class=\"qch-fan-list\">\n              <li class=\"qch-fan-group\">For your team, vendors and partners<\/li>\n                  <li class=\"qch-fan-row is-supported\" id=\"d-excel\">\n                                      <a class=\"rl\" href=\"https:\/\/querystreams.com\/features\/databases-in-excel-and-google-sheets\/\" tabindex=\"-1\" aria-hidden=\"true\"><img loading=\"lazy\" class=\"ri \" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-excel.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\"><\/a>                        <h3><a href=\"https:\/\/querystreams.com\/features\/databases-in-excel-and-google-sheets\/\">Multi-record CSV to Excel<\/a> <span>Microsoft Excel \u00b7 Excel add-in<\/span><\/h3>\n            <p>Pull live Multi-record CSV results straight into a worksheet and refresh them on demand \u2014 desktop Excel, Excel Online, Microsoft 365.<\/p>\n                          <a class=\"qspx-link\" href=\"https:\/\/querystreams.com\/features\/databases-in-excel-and-google-sheets\/\">How Excel works <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i><\/a>\n                      <\/li>\n                  <li class=\"qch-fan-row is-supported\" id=\"d-sheets\">\n                                      <a class=\"rl\" href=\"https:\/\/querystreams.com\/features\/databases-in-excel-and-google-sheets\/\" tabindex=\"-1\" aria-hidden=\"true\"><img loading=\"lazy\" class=\"ri \" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-gsheets.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\"><\/a>                        <h3><a href=\"https:\/\/querystreams.com\/features\/databases-in-excel-and-google-sheets\/\">Multi-record CSV to Google Sheets<\/a> <span>Sheets add-on<\/span><\/h3>\n            <p>Run a saved Multi-record CSV query from the sidebar and drop the rows into the sheet. Shared collaborators can refresh it themselves.<\/p>\n                          <a class=\"qspx-link\" href=\"https:\/\/querystreams.com\/features\/databases-in-excel-and-google-sheets\/\">How Google Sheets works <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i><\/a>\n                      <\/li>\n                  <li class=\"qch-fan-row is-extra\" id=\"d-nova\">\n                                      <a class=\"rl\" href=\"https:\/\/querystreams.com\/features\/text-to-sql\/\" tabindex=\"-1\" aria-hidden=\"true\"><img loading=\"lazy\" class=\"ri nova\" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/03\/nova_128x128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\"><\/a>                        <h3><a href=\"https:\/\/querystreams.com\/features\/text-to-sql\/\">Ask Nova about Multi-record CSV<\/a> <span>Nova AI \u00b7 text to SQL<\/span><\/h3>\n            <p>Ask a question in plain English. Nova already knows your Multi-record CSV tables, writes and runs the SQL, explains the answer and charts it \u2014 no query to write, no credentials to hand over.<\/p>\n                          <a class=\"qspx-link\" href=\"https:\/\/querystreams.com\/features\/text-to-sql\/\">How Nova works <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i><\/a>\n                      <\/li>\n                  <li class=\"qch-fan-row is-extra\" id=\"d-viewer\">\n                                      <a class=\"rl\" href=\"https:\/\/querystreams.com\/features\/database-viewer\/\" tabindex=\"-1\" aria-hidden=\"true\"><img loading=\"lazy\" class=\"ri \" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-sharing.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\"><\/a>                        <h3><a href=\"https:\/\/querystreams.com\/features\/database-viewer\/\">Multi-record CSV to Data Viewer<\/a> <span>result sharing \u00b7 team, vendors, partners \u00b7 phone, tablet, desktop<\/span><\/h3>\n            <p>Share a live Multi-record CSV result with anyone \u2014 a colleague, a vendor, a partner \u2014 as a bookmarkable grid that re-runs fresh when opened, on a phone, a tablet or a desktop. They see the results, never the SQL or the files.<\/p>\n                          <a class=\"qspx-link\" href=\"https:\/\/querystreams.com\/features\/database-viewer\/\">How the Data Viewer works <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i><\/a>\n                      <\/li>\n                      <li class=\"qch-fan-group\">For apps and systems<\/li>\n                  <li class=\"qch-fan-row is-supported\" id=\"d-restapi\">\n                                      <a class=\"rl\" href=\"https:\/\/querystreams.com\/features\/database-rest-api\/\" tabindex=\"-1\" aria-hidden=\"true\"><img loading=\"lazy\" class=\"ri \" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-restapi.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\"><\/a>                        <h3><a href=\"https:\/\/querystreams.com\/features\/database-rest-api\/\">Multi-record CSV REST API<\/a> <span>HTTP endpoint<\/span><\/h3>\n            <p>Publish a Multi-record CSV query as an authenticated JSON endpoint any application can call, with an OpenAPI 3.1 spec and ready-made Postman, Insomnia and Hoppscotch collections. No database port is opened.<\/p>\n                          <a class=\"qspx-link\" href=\"https:\/\/querystreams.com\/features\/database-rest-api\/\">How REST API works <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i><\/a>\n                      <\/li>\n                  <li class=\"qch-fan-row is-supported\" id=\"d-powerbi\">\n                                      <a class=\"rl\" href=\"https:\/\/querystreams.com\/docs\/power-bi-rest-api\/\" tabindex=\"-1\" aria-hidden=\"true\"><img loading=\"lazy\" class=\"ri \" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-powerbi.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\"><\/a>                        <h3><a href=\"https:\/\/querystreams.com\/docs\/power-bi-rest-api\/\">Multi-record CSV to Power BI<\/a> <span>Power Query M<\/span><\/h3>\n            <p>Paste the generated Power Query M into the Power BI Advanced Editor and the report reads live Multi-record CSV results over HTTPS \u2014 no ODBC driver, no database port opened.<\/p>\n                          <a class=\"qspx-link\" href=\"https:\/\/querystreams.com\/docs\/power-bi-rest-api\/\">How Power BI works <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i><\/a>\n                      <\/li>\n                  <li class=\"qch-fan-row is-supported\" id=\"d-airtable\">\n                                      <a class=\"rl\" href=\"https:\/\/querystreams.com\/features\/automation-integration\/\" tabindex=\"-1\" aria-hidden=\"true\"><img loading=\"lazy\" class=\"ri \" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-airtable.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\"><\/a>                        <h3><a href=\"https:\/\/querystreams.com\/features\/automation-integration\/\">Multi-record CSV to Airtable<\/a> <span>Automation platform<\/span><\/h3>\n            <p>Sync Multi-record CSV rows into an Airtable base on a schedule, or fetch them inside an Airtable automation script.<\/p>\n                          <a class=\"qspx-link\" href=\"https:\/\/querystreams.com\/features\/automation-integration\/\">How Airtable works <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i><\/a>\n                      <\/li>\n                  <li class=\"qch-fan-row is-supported\" id=\"d-baserow\">\n                                      <a class=\"rl\" href=\"https:\/\/querystreams.com\/features\/automation-integration\/\" tabindex=\"-1\" aria-hidden=\"true\"><img loading=\"lazy\" class=\"ri \" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-baserow.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\"><\/a>                        <h3><a href=\"https:\/\/querystreams.com\/features\/automation-integration\/\">Multi-record CSV to Baserow<\/a> <span>Automation platform<\/span><\/h3>\n            <p>Feed a Baserow table from Multi-record CSV over the REST endpoint \u2014 self-hosted or Baserow cloud.<\/p>\n                          <a class=\"qspx-link\" href=\"https:\/\/querystreams.com\/features\/automation-integration\/\">How Baserow works <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i><\/a>\n                      <\/li>\n                  <li class=\"qch-fan-row is-supported\" id=\"d-seatable\">\n                                      <a class=\"rl\" href=\"https:\/\/querystreams.com\/features\/automation-integration\/\" tabindex=\"-1\" aria-hidden=\"true\"><img loading=\"lazy\" class=\"ri \" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-seatable.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\"><\/a>                        <h3><a href=\"https:\/\/querystreams.com\/features\/automation-integration\/\">Multi-record CSV to SeaTable<\/a> <span>Automation platform<\/span><\/h3>\n            <p>Keep a SeaTable base current with Multi-record CSV data without exporting a file or exposing the database.<\/p>\n                          <a class=\"qspx-link\" href=\"https:\/\/querystreams.com\/features\/automation-integration\/\">How SeaTable works <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i><\/a>\n                      <\/li>\n                  <li class=\"qch-fan-row is-supported\" id=\"d-smartsheet\">\n                                      <a class=\"rl\" href=\"https:\/\/querystreams.com\/features\/automation-integration\/\" tabindex=\"-1\" aria-hidden=\"true\"><img loading=\"lazy\" class=\"ri \" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-smartsheet.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\"><\/a>                        <h3><a href=\"https:\/\/querystreams.com\/features\/automation-integration\/\">Multi-record CSV to Smartsheet<\/a> <span>Automation platform<\/span><\/h3>\n            <p>Push Multi-record CSV results into a Smartsheet grid so plans and reports read from the source system, not last week&#039;s export.<\/p>\n                          <a class=\"qspx-link\" href=\"https:\/\/querystreams.com\/features\/automation-integration\/\">How Smartsheet works <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i><\/a>\n                      <\/li>\n                  <li class=\"qch-fan-row is-supported\" id=\"d-anvil\">\n                                      <a class=\"rl\" href=\"https:\/\/querystreams.com\/features\/automation-integration\/\" tabindex=\"-1\" aria-hidden=\"true\"><img loading=\"lazy\" class=\"ri \" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-anvil.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\"><\/a>                        <h3><a href=\"https:\/\/querystreams.com\/features\/automation-integration\/\">Multi-record CSV to Anvil<\/a> <span>Anvil Works \u00b7 App platform<\/span><\/h3>\n            <p>Back an Anvil Python app with Multi-record CSV through the REST endpoint instead of embedding database credentials in the app.<\/p>\n                          <a class=\"qspx-link\" href=\"https:\/\/querystreams.com\/features\/automation-integration\/\">How Anvil works <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i><\/a>\n                      <\/li>\n                      <li class=\"qch-fan-group\">For AI tools<\/li>\n                  <li class=\"qch-fan-row is-supported\" id=\"d-mcp\">\n                                      <a class=\"rl\" href=\"https:\/\/querystreams.com\/features\/mcp-server\/\" tabindex=\"-1\" aria-hidden=\"true\"><img loading=\"lazy\" class=\"ri \" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-mcp.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\"><\/a>                        <h3><a href=\"https:\/\/querystreams.com\/features\/mcp-server\/\">Multi-record CSV MCP server<\/a> <span>Claude, Cursor and MCP clients<\/span><\/h3>\n            <p>Give an AI assistant read-only access to Multi-record CSV with the schema it needs to write correct SQL \u2014 no credentials in the chat.<\/p>\n                          <a class=\"qspx-link\" href=\"https:\/\/querystreams.com\/features\/mcp-server\/\">How MCP works <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i><\/a>\n                      <\/li>\n                      <li class=\"qch-fan-group\">Delivered to people<\/li>\n                  <li class=\"qch-fan-row is-supported\" id=\"d-alerts\">\n                                      <a class=\"rl\" href=\"https:\/\/querystreams.com\/features\/automated-reports\/\" tabindex=\"-1\" aria-hidden=\"true\"><img loading=\"lazy\" class=\"ri \" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2026\/08\/docs-alerts.transparent.128.png\" width=\"30\" height=\"30\" alt=\"\" loading=\"lazy\" decoding=\"async\"><\/a>                        <h3><a href=\"https:\/\/querystreams.com\/features\/automated-reports\/\">Multi-record CSV alerts and reports<\/a> <span>Slack \u00b7 Discord \u00b7 Email \u00b7 Webhook<\/span><\/h3>\n            <p>Put a Multi-record CSV query on a schedule and have the rows delivered to Slack, Discord, email or a signed webhook \u2014 or hold the message until a row count, threshold or percentage change crosses the line you set.<\/p>\n                          <a class=\"qspx-link\" href=\"https:\/\/querystreams.com\/features\/automated-reports\/\">How alerts and reports work <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i><\/a>\n                      <\/li>\n                  <\/ol>\n    <\/div>\n  <\/section>\n\n  <section class=\"qspx-section qspx-how\" id=\"how\">\n    <div class=\"qspx-shead\">\n      <p class=\"qspx-eyebrow\">How it works<\/p>\n      <h2 class=\"qspx-h2\">5 steps, no inbound firewall change<\/h2>\n    <\/div>\n    <div class=\"qch-steps\">\n              <div class=\"qspx-step\">\n          <span class=\"n\"><b>01<\/b><em><\/em><\/span>\n          <p>Install the Network Agent where it can see the folder of tagged CSVs \u2014 panel-saw and machine exports, EDI-style drops, fixed-format interchange files.<\/p>\n        <\/div>\n              <div class=\"qspx-step\">\n          <span class=\"n\"><b>02<\/b><em><\/em><\/span>\n          <p>Point the connector at it and say which column holds the record tag. It is column 1 in most of these formats.<\/p>\n        <\/div>\n              <div class=\"qspx-step\">\n          <span class=\"n\"><b>03<\/b><em><\/em><\/span>\n          <p>The agent reads each line, looks at its tag, and routes it to the table for that record type. A file holding PNLHDR header lines and PNL1 detail lines becomes two proper tables instead of one unusable blob.<\/p>\n        <\/div>\n              <div class=\"qspx-step\">\n          <span class=\"n\"><b>04<\/b><em><\/em><\/span>\n          <p>Each row keeps its _source_file, plus a _seq number counting that record type through the file \u2014 which is what lets you tie a header back to the lines belonging to it.<\/p>\n        <\/div>\n              <div class=\"qspx-step\">\n          <span class=\"n\"><b>05<\/b><em><\/em><\/span>\n          <p>Query each record type on its own, or join them back together.<\/p>\n        <\/div>\n          <\/div>\n  <\/section>\n\n          <section class=\"qspx-section\" id=\"features\">\n      <div class=\"qspx-shead\">\n        <p class=\"qspx-eyebrow\">Feature deep-dive<\/p>\n        <h2 class=\"qspx-h2\">What Multi-record CSV gives you<\/h2>\n      <\/div>\n              <div class=\"qch-feats\">\n                      <article class=\"qch-feat\">\n              <h3>Why this card exists<\/h3>              <p>Ordinary CSV tools assume one rectangular layout per file: one header row, then rows that all match it. Machine and interchange formats break that rule on purpose. Every line begins with a tag saying what kind of record it is, and each type has a different number of fields. Point a normal CSV importer at one of these and you get an error or garbage columns.<\/p>                                        <\/article>\n                      <article class=\"qch-feat\">\n              <h3>How the tables come out<\/h3>                                            <ul>\n                                      <li><i class=\"fa-solid fa-circle-check\" aria-hidden=\"true\"><\/i>\n                      <span><b>One table per tag<\/b> \u2014 named from the tag itself, so PNLHDR and PNL1 become their own tables.<\/span><\/li>\n                                      <li><i class=\"fa-solid fa-circle-check\" aria-hidden=\"true\"><\/i>\n                      <span>Fields land as field_1, field_2 and so on in the order they appear, with the tag column left out.<\/span><\/li>\n                                      <li><i class=\"fa-solid fa-circle-check\" aria-hidden=\"true\"><\/i>\n                      <span>_seq numbers each record of a given type within its file, so a header and the detail lines under it can be matched up.<\/span><\/li>\n                                      <li><i class=\"fa-solid fa-circle-check\" aria-hidden=\"true\"><\/i>\n                      <span>Types are worked out per field, per tag, and checked for agreement across the files before anything is pinned.<\/span><\/li>\n                                  <\/ul>\n                                            <pre class=\"qch-code\"><code>-- Panels cut, per export file\nSELECT   _source_file, COUNT(*) AS panels\nFROM     data_pnl1\nGROUP BY _source_file<\/code><\/pre>\n                          <\/article>\n                      <article class=\"qch-feat\">\n              <h3>Errors are named, never swallowed<\/h3>              <p>If a line carries the wrong number of fields for its tag, an unrecognised tag, or a value that does not fit, the whole file is held back and the report names the file, the line number and the tag \u2014 up to twenty of them, then a count of the rest. Nothing loads partially, so you are never chasing a total that is quietly short by three rows.<\/p>                                        <\/article>\n                      <article class=\"qch-feat\">\n              <h3>Not sure which card you need<\/h3>              <p>If every line in the file has the same shape and there is a single header row, CSV Folder is the right card. Use this one only when a tag column decides what each line means.<\/p>                                        <\/article>\n                  <\/div>\n                                    <div class=\"qspx-wrap\">\n        <div class=\"qch-famband\">\n          <p class=\"qch-famband-hd\">\n            <i class=\"fa-solid fa-folder-tree\" aria-hidden=\"true\"><\/i>\n            Shared by the whole File Set family          <\/p>\n          <div class=\"qch-famband-cols\">\n                          <div class=\"qch-famband-col\">\n                <h3>Every folder connector also gives you<\/h3>                                                  <ul>\n                                          <li><i class=\"fa-solid fa-circle-check\" aria-hidden=\"true\"><\/i>\n                        <span><b>files_current<\/b> \u2014 a live inventory: every file the connector can see right now, with its path, size and modified date.<\/span><\/li>\n                                          <li><i class=\"fa-solid fa-circle-check\" aria-hidden=\"true\"><\/i>\n                        <span><b>files_events<\/b> \u2014 the audit trail: what appeared, what changed, what vanished, and anything held back, with the filename and the reason.<\/span><\/li>\n                                          <li><i class=\"fa-solid fa-circle-check\" aria-hidden=\"true\"><\/i>\n                        <span><b>directories and volumes<\/b> \u2014 per-folder totals, daily growth history, and how much room is left on the drive.<\/span><\/li>\n                                          <li><i class=\"fa-solid fa-circle-check\" aria-hidden=\"true\"><\/i>\n                        <span>Only files that actually changed are re-read on each sync, so a folder of 50,000 files is not re-parsed because one new export landed.<\/span><\/li>\n                                      <\/ul>\n                              <\/div>\n                          <div class=\"qch-famband-col\">\n                <h3>Good to know<\/h3>                                                  <ul>\n                                          <li><i class=\"fa-solid fa-circle-check\" aria-hidden=\"true\"><\/i>\n                        <span><b>Read-only, enforced<\/b> \u2014 one statement at a time, SELECT and friends only. Your files are never written, moved or renamed.<\/span><\/li>\n                                          <li><i class=\"fa-solid fa-circle-check\" aria-hidden=\"true\"><\/i>\n                        <span><b>Nothing is uploaded<\/b> \u2014 the data is cached, encrypted, on your own machine beside the agent. Only the result of a query leaves your network.<\/span><\/li>\n                                          <li><i class=\"fa-solid fa-circle-check\" aria-hidden=\"true\"><\/i>\n                        <span><b>Sensible defaults<\/b> \u2014 up to 250,000 files, 16 folders deep, 512 MB per file, all adjustable. Recycle bins, .git and node_modules are always skipped.<\/span><\/li>\n                                          <li><i class=\"fa-solid fa-circle-check\" aria-hidden=\"true\"><\/i>\n                        <span><b>The SQL dialect is DuckDB<\/b> \u2014 the same SQL you would write against any other connector.<\/span><\/li>\n                                      <\/ul>\n                              <\/div>\n                      <\/div>\n        <\/div>\n        <\/div>\n          <\/section>\n  \n      <section class=\"qspx-section\" id=\"federated\">\n    <div class=\"qspx-shead\">\n      <p class=\"qspx-eyebrow\">Cross-source SQL<\/p>\n      <h2 class=\"qspx-h2\">Join Multi-record CSV to the rest of your data<\/h2>\n            <p>\n        A folder of files is a set of SQL tables like any other, so one statement can join it to a database and an API at once.        Each source runs only the part it can, streams the result back, and the join happens centrally \u2014 the sources never talk to each other and nothing is copied anywhere.      <\/p>\n    <\/div>\n\n        <div class=\"qch-fed\">\n      <div class=\"qch-fed-panel\">\n        <div class=\"qch-fed-src\">\n          <p class=\"qch-fed-lbl\">\n            3 connections \u00b7 3 agents          <\/p>\n                      <div class=\"qch-fed-row qch-fed-a1\">\n                                            <span class=\"qch-fed-num\" aria-hidden=\"true\">1<\/span>\n                            <span class=\"qch-fed-ic\" aria-hidden=\"true\">\n                                  <img loading=\"lazy\" src=\"https:\/\/my.querystreams.com\/data-sources\/icon-recordtype-csv.svg\" width=\"22\" height=\"22\" alt=\"\" loading=\"lazy\" decoding=\"async\">\n                              <\/span>\n              <span class=\"qch-fed-nm\">\n                <b>Multi-record CSV<\/b>\n                <i>Tagged records<\/i>              <\/span>\n            <\/div>\n                      <div class=\"qch-fed-row qch-fed-a2\">\n                                            <span class=\"qch-fed-num\" aria-hidden=\"true\">2<\/span>\n                            <span class=\"qch-fed-ic\" aria-hidden=\"true\">\n                                  <img loading=\"lazy\" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2025\/09\/postgreesql-40.png\" width=\"22\" height=\"22\" alt=\"\" loading=\"lazy\" decoding=\"async\">\n                              <\/span>\n              <span class=\"qch-fed-nm\">\n                <b>PostgreSQL<\/b>\n                <i>Relational engine<\/i>              <\/span>\n            <\/div>\n                      <div class=\"qch-fed-row qch-fed-a3\">\n                                            <span class=\"qch-fed-num\" aria-hidden=\"true\">3<\/span>\n                            <span class=\"qch-fed-ic\" aria-hidden=\"true\">\n                                  <img loading=\"lazy\" src=\"https:\/\/querystreams.com\/wp-content\/uploads\/2025\/12\/icon-stripe.png\" width=\"22\" height=\"22\" alt=\"\" loading=\"lazy\" decoding=\"async\">\n                              <\/span>\n              <span class=\"qch-fed-nm\">\n                <b>Stripe<\/b>\n                <i>Payments &amp; billing<\/i>              <\/span>\n            <\/div>\n                  <\/div>\n\n                  <div class=\"qch-fed-stmt\">\n            <p class=\"qch-fed-lbl\">One statement<\/p>\n                        <pre class=\"qch-code qch-fed-sql\"><code><span class=\"cm\">-- nothing copied, nothing merged, nothing scheduled<\/span>\n<span class=\"kw\">SELECT<\/span>   c.region, COUNT(*) AS orders, SUM(i.amount_due) AS invoiced\n<span class=\"kw\">FROM<\/span>     <span class=\"qch-fed-tok qch-fed-a1\"><b>machine_csv<\/b>.fileset.data_pnlhdr<span class=\"qch-fed-tok-n\">1<\/span><\/span> f\n<span class=\"kw\">JOIN<\/span>     <span class=\"qch-fed-tok qch-fed-a2\"><b>pg_crm<\/b>.public.customers<span class=\"qch-fed-tok-n\">2<\/span><\/span>         c ON c.id = f.customer_id\n<span class=\"kw\">JOIN<\/span>     <span class=\"qch-fed-tok qch-fed-a3\"><b>billing<\/b>.stripe.invoices<span class=\"qch-fed-tok-n\">3<\/span><\/span>         i ON i.customer = c.stripe_id\n<span class=\"kw\">GROUP BY<\/span> c.region\n<span class=\"kw\">ORDER BY<\/span> invoiced DESC;<\/code><\/pre>\n          <\/div>\n              <\/div>\n      <p class=\"qch-fed-foot\">\n                  The three parts are connection, schema and table \u2014 and the connection name is whatever you called it. Illustrative columns; your tables will be your tables.                                    Read-only applies to every piece: SELECT, WITH and EXPLAIN only, with a ceiling on how much any one source may hand over for a single query.        <a href=\"https:\/\/querystreams.com\/features\/federated-queries\/\">\n          How federated queries work        <\/a>\n      <\/p>\n    <\/div>\n  <\/section>\n\n  <section class=\"qspx-section qch-conn\" id=\"connect\">\n    <div class=\"qspx-shead\">\n      <p class=\"qspx-eyebrow\">Connection details<\/p>\n      <h2 class=\"qspx-h2\">What Multi-record CSV needs<\/h2>\n    <\/div>\n                        <dl class=\"qch-spec\">\n                      <div>\n              <dt>Folder<\/dt>\n              <dd>One or more roots holding tagged CSV exports, subfolders included \u2014 panel-saw and machine output, EDI-style drops, fixed-format interchange files<\/dd>\n            <\/div>\n                      <div>\n              <dt>Tag column<\/dt>\n              <dd>The column holding the record tag \u2014 column 1 by default, which is where these formats almost always put it<\/dd>\n            <\/div>\n                      <div>\n              <dt>Tables<\/dt>\n              <dd>One per tag, named from the tag itself \u2014 a file of PNLHDR header lines and PNL1 detail lines becomes data_pnlhdr and data_pnl1<\/dd>\n            <\/div>\n                      <div>\n              <dt>Columns<\/dt>\n              <dd>field_1, field_2 and so on in the order they appear, with the tag column left out; types are worked out per field, per tag, and checked for agreement across files before anything is pinned<\/dd>\n            <\/div>\n                      <div>\n              <dt>Row keys<\/dt>\n              <dd>_source_file names the export and _seq counts each record of that type through the file, which is what lets a header be matched to the detail lines under it<\/dd>\n            <\/div>\n                      <div>\n              <dt>Errors<\/dt>\n              <dd>A wrong field count, an unrecognised tag or a value that does not fit holds the whole file back; the report names the file, the line number and the tag, up to twenty of them, then a count of the rest<\/dd>\n            <\/div>\n                      <div>\n              <dt>Limits<\/dt>\n              <dd>Up to 250,000 files, 16 folder levels deep, 512 MB per file \u2014 all adjustable<\/dd>\n            <\/div>\n                      <div>\n              <dt>Credentials<\/dt>\n              <dd>None \u2014 there is no server; the agent reads the files in place<\/dd>\n            <\/div>\n                      <div>\n              <dt>SQL dialect<\/dt>\n              <dd>DuckDB \u2014 standard SQL, nothing format-specific to learn<\/dd>\n            <\/div>\n                  <\/dl>\n                    <div class=\"qch-notes\">\n                      <p>There is no database server in this picture. The agent reads the files where they already live, caches the rows in an encrypted DuckDB store on the same machine, and re-reads only files that actually changed \u2014 a year of machine exports is not re-parsed because this morning&#039;s landed. Nothing is uploaded to Query Streams; the only thing that ever leaves your network is the result of a query.<\/p>\n                      <p>Ordinary CSV tools assume one rectangular layout per file: a header row, then rows that all match it. Machine and interchange formats break that rule on purpose \u2014 every line begins with a tag saying what kind of record it is, and each type carries a different number of fields. Point a normal importer at one of these and you get an error or garbage columns. If every line in your file does have the same shape and there is a single header row, CSV Folder is the card you want; use this one only when a tag column decides what each line means.<\/p>\n                  <\/div>\n                <\/section>\n\n      <section class=\"qspx-section\" id=\"related\">\n      <div class=\"qspx-shead\">\n        <p class=\"qspx-eyebrow\">Same folder engine<\/p>\n        <h2 class=\"qspx-h2\">The rest of the File Set family<\/h2>\n        <p>One engine, different file formats \u2014 the inventory tables, change trail and refusal behaviour are identical across the family.<\/p>\n      <\/div>\n      <div class=\"qch-sibs\">\n                  <a class=\"qspx-chip\" href=\"https:\/\/querystreams.com\/database-integrations\/file-system\/\">\n            <span class=\"qspx-chip-ic\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/my.querystreams.com\/data-sources\/icon-fileset.svg\" width=\"20\" height=\"20\" alt=\"\" loading=\"lazy\"><\/span>\n            File System          <\/a>\n                  <a class=\"qspx-chip\" href=\"https:\/\/querystreams.com\/database-integrations\/csv-folder\/\">\n            <span class=\"qspx-chip-ic\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/my.querystreams.com\/data-sources\/icon-csv-folder.svg\" width=\"20\" height=\"20\" alt=\"\" loading=\"lazy\"><\/span>\n            CSV Folder          <\/a>\n                  <a class=\"qspx-chip\" href=\"https:\/\/querystreams.com\/database-integrations\/parquet-folder\/\">\n            <span class=\"qspx-chip-ic\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/my.querystreams.com\/data-sources\/icon-parquet-folder.svg\" width=\"20\" height=\"20\" alt=\"\" loading=\"lazy\"><\/span>\n            Parquet Folder          <\/a>\n                  <a class=\"qspx-chip\" href=\"https:\/\/querystreams.com\/database-integrations\/excel-folder\/\">\n            <span class=\"qspx-chip-ic\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/my.querystreams.com\/data-sources\/icon-excel-folder.svg\" width=\"20\" height=\"20\" alt=\"\" loading=\"lazy\"><\/span>\n            Excel Folder          <\/a>\n                  <a class=\"qspx-chip\" href=\"https:\/\/querystreams.com\/database-integrations\/sqlite-folder\/\">\n            <span class=\"qspx-chip-ic\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/my.querystreams.com\/data-sources\/icon-sqlite-folder.svg\" width=\"20\" height=\"20\" alt=\"\" loading=\"lazy\"><\/span>\n            SQLite Folder          <\/a>\n                  <a class=\"qspx-chip\" href=\"https:\/\/querystreams.com\/database-integrations\/jsonl-folder\/\">\n            <span class=\"qspx-chip-ic\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/my.querystreams.com\/data-sources\/icon-jsonl-folder.svg\" width=\"20\" height=\"20\" alt=\"\" loading=\"lazy\"><\/span>\n            JSONL Folder          <\/a>\n                  <a class=\"qspx-chip\" href=\"https:\/\/querystreams.com\/database-integrations\/machine-logs\/\">\n            <span class=\"qspx-chip-ic\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/my.querystreams.com\/data-sources\/icon-machine-logs.svg\" width=\"20\" height=\"20\" alt=\"\" loading=\"lazy\"><\/span>\n            Machine Logs          <\/a>\n                  <a class=\"qspx-chip\" href=\"https:\/\/querystreams.com\/database-integrations\/web-server-logs\/\">\n            <span class=\"qspx-chip-ic\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/my.querystreams.com\/data-sources\/icon-web-server-logs.svg\" width=\"20\" height=\"20\" alt=\"\" loading=\"lazy\"><\/span>\n            Web Server Logs          <\/a>\n              <\/div>\n    <\/section>\n  \n  <section class=\"qspx-section\" id=\"faq\">\n    <div class=\"qspx-shead\">\n      <p class=\"qspx-eyebrow\">FAQ<\/p>\n      <h2 class=\"qspx-h2\">Questions about Multi-record CSV<\/h2>\n    <\/div>\n    <div class=\"qch-faq\">\n              <details>\n          <summary><i class=\"fa-solid fa-chevron-right\" aria-hidden=\"true\"><\/i><span>Which tools can read Multi-record CSV data through Query Streams?<\/span><\/summary>\n          <p>All of them, from one connection: Excel, Google Sheets, MCP, REST API, Airtable, Baserow, SeaTable, Smartsheet, Anvil, Power BI, scheduled alerts and reports. Connect the folder once and every surface reads the same read-only connection \u2014 there is no per-tool setup and no second copy of the data.<\/p>\n        <\/details>\n              <details>\n          <summary><i class=\"fa-solid fa-chevron-right\" aria-hidden=\"true\"><\/i><span>Do my files get uploaded to Query Streams?<\/span><\/summary>\n          <p>No. The Network Agent reads the files in place and caches rows in an encrypted store on the same machine. The files themselves never leave your network \u2014 only the result rows of a query do, over a single outbound encrypted connection with no inbound firewall port.<\/p>\n        <\/details>\n              <details>\n          <summary><i class=\"fa-solid fa-chevron-right\" aria-hidden=\"true\"><\/i><span>Can Query Streams change, move or rename my files?<\/span><\/summary>\n          <p>No. Files are opened strictly read-only and are never written, moved or renamed. Queries are enforced read-only at the point of execution \u2014 one statement at a time, SELECT and friends only.<\/p>\n        <\/details>\n              <details>\n          <summary><i class=\"fa-solid fa-chevron-right\" aria-hidden=\"true\"><\/i><span>What does Query Streams need to connect to Multi-record CSV?<\/span><\/summary>\n          <p>A folder path the agent machine can see \u2014 no server, no credentials, no drivers to install. Folder: One or more roots holding tagged CSV exports, subfolders included \u2014 panel-saw and machine output, EDI-style drops, fixed-format interchange files. Tag column: The column holding the record tag \u2014 column 1 by default, which is where these formats almost always put it. Tables: One per tag, named from the tag itself \u2014 a file of PNLHDR header lines and PNL1 detail lines becomes data_pnlhdr and data_pnl1. Columns: field_1, field_2 and so on in the order they appear, with the tag column left out; types are worked out per field, per tag, and checked for agreement across files before anything is pinned.<\/p>\n        <\/details>\n              <details>\n          <summary><i class=\"fa-solid fa-chevron-right\" aria-hidden=\"true\"><\/i><span>Can I join a folder of files to a database in the same query?<\/span><\/summary>\n          <p>Yes \u2014 that is a federated query. One statement can reference Multi-record CSV and your other connections at once, written as connection.schema.table. Each source runs only the part it can and streams the result back; the join happens centrally, so the sources never connect to each other and nothing is copied or scheduled. Read-only applies to every piece \u2014 SELECT, WITH and EXPLAIN only \u2014 and there is a ceiling on how much any one source may hand over for a single query. Federated queries are a plan feature; the federated queries page carries the current source and size limits.<\/p>\n        <\/details>\n          <\/div>\n  <\/section>\n\n  <section class=\"qspx-cta\">\n   <div class=\"qspx-wrap\">\n    <div class=\"qspx-cta-card\">\n      <h2 class=\"qspx-h2\">Put Multi-record CSV where the work happens<\/h2>\n      <p class=\"qspx-lede\">Install the agent, point it at your folder, and pick a destination.<\/p>\n      <div class=\"qspx-ctas\">\n        <a class=\"qspx-btn qspx-btn-primary\" href=\"https:\/\/my.querystreams.com\">\n          Start free <i class=\"fa-solid fa-arrow-right\" aria-hidden=\"true\"><\/i>\n        <\/a>\n        <a class=\"qspx-btn qspx-btn-ghost\" href=\"https:\/\/querystreams.com\/database-integrations\/\">\n          <i class=\"fa-solid fa-grid-2\" aria-hidden=\"true\"><\/i> All connectors\n        <\/a>\n      <\/div>\n      <p class=\"qspx-reassure\">\n        <i class=\"fa-solid fa-lock\" aria-hidden=\"true\"><\/i> Read-only\n        <i class=\"fa-solid fa-shield-halved\" aria-hidden=\"true\"><\/i> Outbound only\n        <i class=\"fa-solid fa-key\" aria-hidden=\"true\"><\/i> Credentials stay on the agent\n      <\/p>\n    <\/div>\n   <\/div>\n  <\/section>\n\n  <script>\n(function(){\n  var NS='http:\/\/www.w3.org\/2000\/svg';\n  document.querySelectorAll('[data-qch-fan]').forEach(function(fan){\n    var svg=fan.querySelector('.qch-fan-lines'),src=fan.querySelector('[data-fan-src]'),agent=fan.querySelector('[data-fan-agent]');\n    var dests=[].slice.call(fan.querySelectorAll('.qch-fan-dest'));\n    if(!svg||!src||!agent)return;\n    function box(el){var r=el.getBoundingClientRect(),f=fan.getBoundingClientRect();return {l:r.left-f.left,r:r.right-f.left,cy:r.top-f.top+r.height\/2};}\n    function path(d,cls){var p=document.createElementNS(NS,'path');p.setAttribute('d',d);if(cls)p.setAttribute('class',cls);return p;}\n    function draw(){\n      if(getComputedStyle(svg).display==='none')return;\n      var f=fan.getBoundingClientRect();svg.setAttribute('viewBox','0 0 '+f.width+' '+f.height);\n      var s=box(src),a=box(agent),out=[];\n      var x1=s.r-6,x2=a.l,mx=(x1+x2)\/2;\n      out.push(path('M'+x1+' '+s.cy+' C'+mx+' '+s.cy+' '+mx+' '+a.cy+' '+x2+' '+a.cy,'is-flow'));\n      var ghost=fan.querySelector('[data-fan-ghost]');\n      if(ghost){var g=box(ghost),gx=(g.r+x2)\/2;out.push(path('M'+(g.r-4)+' '+g.cy+' C'+gx+' '+g.cy+' '+gx+' '+a.cy+' '+x2+' '+a.cy,'is-ghost'));}\n      dests.forEach(function(el){\n        var p=box(el),x3=a.r,x4=p.l,m=(x3+x4)\/2;\n        var q=path('M'+x3+' '+a.cy+' C'+m+' '+a.cy+' '+m+' '+p.cy+' '+x4+' '+p.cy);\n        q.setAttribute('data-for',el.getAttribute('href').slice(1));out.push(q);\n      });\n      while(svg.firstChild)svg.removeChild(svg.firstChild);\n      out.forEach(function(p){svg.appendChild(p);});\n    }\n    function hot(el,on){\n      var id=el.getAttribute('href').slice(1),p=svg.querySelector('[data-for=\"'+id+'\"]');\n      if(p)p.classList.toggle('is-hot',on);el.classList.toggle('is-hot',on);\n      (el.getAttribute('data-rows')||'').split(' ').forEach(function(r){var row=r&&document.getElementById(r);if(row)row.classList.toggle('is-hot',on);});\n    }\n    dests.forEach(function(el){\n      el.addEventListener('mouseenter',function(){hot(el,true);});el.addEventListener('mouseleave',function(){hot(el,false);});\n      el.addEventListener('focus',function(){hot(el,true);});el.addEventListener('blur',function(){hot(el,false);});\n    });\n    draw();window.addEventListener('resize',draw);\n    if(document.fonts&&document.fonts.ready)document.fonts.ready.then(draw);\n    fan.querySelectorAll('img').forEach(function(i){if(!i.complete)i.addEventListener('load',draw);});\n  });\n})();\n<\/script>  <script type=\"application\/ld+json\">{\n    \"@context\": \"https:\/\/schema.org\",\n    \"@graph\": [\n        {\n            \"@type\": \"BreadcrumbList\",\n            \"itemListElement\": [\n                {\n                    \"@type\": \"ListItem\",\n                    \"position\": 1,\n                    \"name\": \"Query Streams\",\n                    \"item\": \"https:\/\/querystreams.com\/\"\n                },\n                {\n                    \"@type\": \"ListItem\",\n                    \"position\": 2,\n                    \"name\": \"Database Integrations\",\n                    \"item\": \"https:\/\/querystreams.com\/database-integrations\/\"\n                },\n                {\n                    \"@type\": \"ListItem\",\n                    \"position\": 3,\n                    \"name\": \"Multi-record CSV\",\n                    \"item\": \"https:\/\/querystreams.com\/database-integrations\/multi-record-csv\/\"\n                }\n            ]\n        },\n        {\n            \"@type\": \"FAQPage\",\n            \"mainEntity\": [\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Which tools can read Multi-record CSV data through Query Streams?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"All of them, from one connection: Excel, Google Sheets, MCP, REST API, Airtable, Baserow, SeaTable, Smartsheet, Anvil, Power BI, scheduled alerts and reports. Connect the folder once and every surface reads the same read-only connection \u2014 there is no per-tool setup and no second copy of the data.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Do my files get uploaded to Query Streams?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"No. The Network Agent reads the files in place and caches rows in an encrypted store on the same machine. The files themselves never leave your network \u2014 only the result rows of a query do, over a single outbound encrypted connection with no inbound firewall port.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can Query Streams change, move or rename my files?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"No. Files are opened strictly read-only and are never written, moved or renamed. Queries are enforced read-only at the point of execution \u2014 one statement at a time, SELECT and friends only.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"What does Query Streams need to connect to Multi-record CSV?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"A folder path the agent machine can see \u2014 no server, no credentials, no drivers to install. Folder: One or more roots holding tagged CSV exports, subfolders included \u2014 panel-saw and machine output, EDI-style drops, fixed-format interchange files. Tag column: The column holding the record tag \u2014 column 1 by default, which is where these formats almost always put it. Tables: One per tag, named from the tag itself \u2014 a file of PNLHDR header lines and PNL1 detail lines becomes data_pnlhdr and data_pnl1. Columns: field_1, field_2 and so on in the order they appear, with the tag column left out; types are worked out per field, per tag, and checked for agreement across files before anything is pinned.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can I join a folder of files to a database in the same query?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes \u2014 that is a federated query. One statement can reference Multi-record CSV and your other connections at once, written as connection.schema.table. Each source runs only the part it can and streams the result back; the join happens centrally, so the sources never connect to each other and nothing is copied or scheduled. Read-only applies to every piece \u2014 SELECT, WITH and EXPLAIN only \u2014 and there is a ceiling on how much any one source may hand over for a single query. Federated queries are a plan feature; the federated queries page carries the current source and size limits.\"\n                    }\n                }\n            ]\n        },\n        {\n            \"@type\": \"WebApplication\",\n            \"name\": \"Query Streams\",\n            \"url\": \"https:\/\/querystreams.com\/\",\n            \"applicationCategory\": \"BusinessApplication\",\n            \"operatingSystem\": \"Web\",\n            \"description\": \"Live read-only Multi-record CSV data in Microsoft Excel, Google Sheets, AI assistants (MCP), the REST API and Power BI \u2014 one outbound agent connection, no ODBC drivers, no inbound firewall ports.\",\n            \"offers\": {\n                \"@type\": \"Offer\",\n                \"price\": \"0\",\n                \"priceCurrency\": \"USD\",\n                \"description\": \"Free tier; paid plans from $15\/month\"\n            },\n            \"publisher\": {\n                \"@type\": \"Organization\",\n                \"name\": \"Query Streams\",\n                \"url\": \"https:\/\/querystreams.com\/\"\n            }\n        }\n    ]\n}<\/script>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":5776,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-6106","page","type-page","status-publish","hentry"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"trp-custom-language-flag":false,"betterdocs-category-thumb":false},"uagb_author_info":{"display_name":"systemz","author_link":"https:\/\/querystreams.com\/nl\/author\/systemz\/"},"uagb_comment_info":0,"uagb_excerpt":null,"_links":{"self":[{"href":"https:\/\/querystreams.com\/nl\/wp-json\/wp\/v2\/pages\/6106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/querystreams.com\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/querystreams.com\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/querystreams.com\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/querystreams.com\/nl\/wp-json\/wp\/v2\/comments?post=6106"}],"version-history":[{"count":1,"href":"https:\/\/querystreams.com\/nl\/wp-json\/wp\/v2\/pages\/6106\/revisions"}],"predecessor-version":[{"id":7087,"href":"https:\/\/querystreams.com\/nl\/wp-json\/wp\/v2\/pages\/6106\/revisions\/7087"}],"up":[{"embeddable":true,"href":"https:\/\/querystreams.com\/nl\/wp-json\/wp\/v2\/pages\/5776"}],"wp:attachment":[{"href":"https:\/\/querystreams.com\/nl\/wp-json\/wp\/v2\/media?parent=6106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}