Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.
TypeScript agentaiai-agentsall-in-onecrmcrm-systememaillinearmcpmessagingnotesnotionofficerustslackslack-alternativestartupstartup-toolstypescriptworkspace
import { isFeatureEnabled, showDatabaseSql } from '@core/constant/featureFlags';
import { fireAndForget } from '@core/util/fireAndForget';
import ArrowClockwiseIcon from '@icon/system/regular/arrow-clockwise.svg';
import ArrowUpIcon from '@icon/system/regular/arrow-up.svg';
import CodeIcon from '@icon/system/regular/code.svg';
import PlayIcon from '@icon/system/regular/play.svg';
import TableIcon from '@icon/system/regular/table.svg';
import {
DATABASE_QUERY_CHART_MODES,
type DatabaseQueryDisplayMode,
isDatabaseQueryChartMode,
isDatabaseQueryDisplayMode,
} from '@macro-inc/lexical-core/nodes/databaseQueryData';
import { Telemetry } from '@macro-inc/observability';
import { Button } from '@ui/components/Button';
import { Hotkey } from '@ui/components/Hotkey';
import {
type Accessor,
createSignal,
createUniqueId,
For,
type JSX,
onMount,
Show,
} from 'solid-js';
import { match, P } from 'ts-pattern';
import { QueryResults } from '../components/query-results';
import { QuestionExamples } from '../components/question-examples';
import { SqlEditor } from '../components/sql-editor';
import { useAnswerDisplay } from '../context/answer-display';
import type { QueryCapabilities } from '../context/query-context';
import { unknownNames } from '../core/answer-cell';
import {
isScalarAnswer,
type QueryDefinition,
type QuerySchema,
queryFocusTable,
} from '../core/query';
import {
availableDisplayModes,
chartModeLabel,
prepareQueryChart,
} from '../core/query-chart';
import { questionExamples } from '../core/question-examples';
import { createQueryComposer } from '../primitives/query-composer';
export function QueryEditor(props: {
schema: QuerySchema;
initial: QueryDefinition;
capabilities: QueryCapabilities;
sourceAvailable?: boolean;
sourcePicker?: JSX.Element | ((schema: Accessor<QuerySchema>) => JSX.Element);
onSave?: (definition: QueryDefinition) => void;
saveLabel?: string;
autoFocus?: boolean;
/** Editing a saved document answer commits a successful regeneration directly. */
saveOnGenerate?: boolean;
saving?: boolean;
}) {
const showSql = isFeatureEnabled(showDatabaseSql);
const display = useAnswerDisplay();
const composer = createQueryComposer({
...props.capabilities,
initial: props.initial,
schema: () => props.schema,
showSql,
});
// Build the picker once; reactive schema reads belong inside its props.
// Recreating it on source changes removes the trigger before focus restores.
const sourcePicker =
typeof props.sourcePicker === 'function'
? props.sourcePicker(composer.schema)
: props.sourcePicker;
const promptId = createUniqueId();
let promptInput: HTMLTextAreaElement | undefined;
const [sqlOpen, setSqlOpen] = createSignal(false);
const displayMode = (): DatabaseQueryDisplayMode => {
const preview = composer.preview();
return composer.presentation().displayMode === 'scalar' &&
preview &&
!isScalarAnswer(preview.answer)
? 'table'
: composer.presentation().displayMode;
};
const displayOptions = () => {
const current = composer.preview()?.answer;
if (!current) return [];
return availableDisplayModes(current, {
displayMode: displayMode(),
chart: composer.presentation().chart,
}).map((value) => ({
value,
label: match(value)
.with('scalar', () => 'Inline answer')
.with('table', () => 'Result table')
.with(P.union(...DATABASE_QUERY_CHART_MODES), chartModeLabel)
.exhaustive(),
}));
};
const savedChart = () => {
const current = composer.preview()?.answer;
const mode = displayMode();
return current && isDatabaseQueryChartMode(mode)
? prepareQueryChart(
current,
mode,
composer.presentation().chart,
unknownNames
).data?.config
: undefined;
};
const answer = () =>
composer.isCurrentPreview() ? composer.preview()?.answer : undefined;
const names = display.names(() => composer.preview()?.answer);
const busy = () => composer.phase() !== 'idle' || props.saving === true;
const focusTable = () => queryFocusTable(composer.schema());
const sourceAvailable = () => props.sourceAvailable !== false;
const needsGeneration = () =>
props.saveOnGenerate ||
!composer.sql().trim() ||
composer.needsGeneration();
const canAsk = () =>
!busy() &&
sourceAvailable() &&
!!(needsGeneration() ? composer.prompt().trim() : composer.sql().trim());
const ask = async () => {
if (!canAsk()) return;
const span = Telemetry.span('database.query.regenerate');
try {
await span.run(() =>
needsGeneration() ? composer.generate() : composer.run()
);
span.setAttr('database.outcome', composer.error() ? 'error' : 'success');
} finally {
span.end();
}
if (
props.saveOnGenerate &&
!composer.error() &&
composer.isCurrentPreview()
)
accept();
};
// A current answer is accepted with Enter; changing the prompt asks again.
const canAccept = () => !!answer() && !!props.onSave && !props.saveOnGenerate;
const accept = () => {
if (!answer() || !props.onSave) return;
props.onSave({
databaseId: composer.answerDatabaseId(),
...(composer.tableId() ? { tableId: composer.tableId() } : {}),
sql: composer.sql().trim(),
prompt: composer.prompt().trim(),
title: composer.presentation().title,
displayMode:
isDatabaseQueryChartMode(displayMode()) && !savedChart()
? 'table'
: displayMode(),
...(savedChart() ? { chart: savedChart() } : {}),
});
};
const editPrompt = () => {
if (!promptInput) return;
promptInput.focus();
const end = promptInput.value.length;
promptInput.setSelectionRange(end, end);
};
const isPlainEnter = (event: KeyboardEvent) =>
event.key === 'Enter' &&
!event.shiftKey &&
!event.metaKey &&
!event.ctrlKey &&
!event.altKey &&
!event.isComposing &&
event.keyCode !== 229;
// Controls with their own Enter (buttons, menus, the SQL editor) keep it.
const ownsEnter = (target: EventTarget | null) =>
target instanceof Element &&
!!target.closest(
'button, a, select, input, textarea, [contenteditable="true"]'
);
onMount(() => {
if (props.autoFocus) promptInput?.focus();
if (
!props.saveOnGenerate &&
props.initial.sql.trim() &&
!composer.needsGeneration()
)
fireAndForget(composer.run(), 'database-query');
});
return (
<div
class="flex min-h-0 flex-col gap-3 p-4"
data-database-query-editor
on:keydown={(event) => {
if (!isPlainEnter(event) || !canAccept() || ownsEnter(event.target))
return;
event.preventDefault();
event.stopPropagation();
accept();
}}
>
<form
onSubmit={(event) => {
event.preventDefault();
fireAndForget(ask(), 'database-query');
}}
>
<label class="sr-only" for={promptId}>
What would you like to know?
</label>
<div class="rounded-lg border border-edge bg-input p-3 transition-colors focus-within:border-ink/30 focus-within:ring-2 focus-within:ring-ink/10">
<div class="relative">
<textarea
ref={promptInput}
id={promptId}
aria-label="Ask your database"
class="min-h-16 w-full resize-none bg-transparent text-sm text-ink outline-none placeholder:text-transparent"
placeholder="Ask anything about your data…"
value={composer.prompt()}
onInput={(event) => composer.setPrompt(event.currentTarget.value)}
on:keydown={(event) => {
if (event.isComposing || event.keyCode === 229) return;
if (event.key === 'Enter' && !event.shiftKey) {
event.preventDefault();
event.stopPropagation();
if (canAccept()) accept();
else fireAndForget(ask(), 'database-query');
}
}}
/>
<Show when={!composer.prompt()}>
<QuestionExamples
examples={questionExamples(composer.schema())}
/>
</Show>
</div>
<Show when={!canAccept()}>
<div class="flex items-center justify-end gap-2">
<Button
variant="primary"
type="submit"
size="sm"
disabled={!canAsk()}
>
<Show
when={busy()}
fallback={
<>
{props.saveOnGenerate
? 'Regenerate'
: composer.preview() && composer.needsGeneration()
? 'Update answer'
: 'Ask'}{' '}
<ArrowUpIcon class="size-3.5" />
</>
}
>
{props.saving
? 'Saving…'
: composer.phase() === 'generating'
? 'Thinking…'
: 'Finding answer…'}
</Show>
</Button>
</div>
</Show>
</div>
</form>
<div class="flex min-w-0 items-center justify-between gap-3 text-xs">
<div class="min-w-0 flex-1">
<Show
when={sourcePicker}
fallback={
<div class="flex min-w-0 items-center gap-1.5 text-ink-muted">
<TableIcon class="size-3.5 shrink-0" />
<span
class="truncate"
title={focusTable()?.name ?? composer.schema().name}
>
{focusTable()?.name ?? composer.schema().name}
</span>
<Show when={focusTable()}>
<span class="truncate" title={composer.schema().name}>
· {composer.schema().name}
</span>
</Show>
</div>
}
>
{sourcePicker}
</Show>
</div>
<Show when={showSql}>
<button
type="button"
class="flex h-7 shrink-0 items-center gap-1.5 rounded-md px-1.5 text-xs text-ink-muted outline-none hover:bg-hover hover:text-ink focus-visible:ring-2 focus-visible:ring-ink/50"
aria-expanded={sqlOpen()}
onClick={() => setSqlOpen(!sqlOpen())}
>
<CodeIcon class="size-3.5" /> {sqlOpen() ? 'Hide SQL' : 'SQL'}
</button>
</Show>
</div>
<Show when={!sourceAvailable()}>
<p class="text-xs text-ink-muted">
Choose an available database to update this answer.
</p>
</Show>
<Show when={showSql && sqlOpen()}>
<div>
<SqlEditor
value={composer.sql()}
schema={composer.schema()}
onChange={composer.setSql}
onRun={() => fireAndForget(composer.run(), 'database-query')}
/>
<div class="mt-1.5 flex items-center justify-between gap-2">
<p class="text-[11px] text-ink-muted">
Read-only SQL · ⌘ / Ctrl + Enter to run
</p>
<Button
variant="ghost"
size="sm"
disabled={busy() || !composer.sql().trim()}
onClick={() => fireAndForget(composer.run(), 'database-query')}
>
<PlayIcon class="size-3.5" /> Run SQL
</Button>
</div>
</div>
</Show>
<Show when={composer.canUndo()}>
<button
class="self-start text-xs text-ink-muted underline decoration-edge underline-offset-2 hover:text-ink"
onClick={composer.undoChanges}
>
Undo
</button>
</Show>
<Show when={composer.error()}>
{(message) => (
<div
role="alert"
class="rounded-md border border-failure-ink/20 bg-failure-ink/5 px-3 py-2 text-sm text-failure-ink"
>
<p>{message()}</p>
<Show
when={
showSql &&
composer.errorDetail() &&
composer.errorDetail() !== message()
}
>
<details class="mt-2 text-xs">
<summary>Technical details</summary>
<pre class="mt-1 whitespace-pre-wrap break-words">
{composer.errorDetail()}
</pre>
</details>
</Show>
</div>
)}
</Show>
<Show when={composer.phase() === 'running'}>
<p role="status" class="text-xs text-ink-muted">
Finding your answer…
</p>
</Show>
<Show when={composer.preview()}>
{(preview) => (
<div class="space-y-3">
<div class="flex flex-wrap items-center justify-between gap-2 text-xs">
<Show
when={displayOptions().length > 1}
fallback={<span class="font-medium text-ink">Answer</span>}
>
<select
aria-label="Display answer as"
value={displayMode()}
disabled={busy()}
onChange={(event) => {
const mode = event.currentTarget.value;
if (isDatabaseQueryDisplayMode(mode))
composer.setDisplayMode(mode);
}}
class="h-7 min-w-0 rounded-md border border-transparent bg-transparent px-1 text-xs font-medium text-ink outline-none hover:bg-hover focus-visible:ring-2 focus-visible:ring-ink/25"
>
<For each={displayOptions()}>
{(option) => (
<option
value={option.value}
selected={displayMode() === option.value}
>
{option.label}
</option>
)}
</For>
</select>
</Show>
<div class="flex items-center gap-2 text-ink-muted">
<Show when={!composer.isCurrentPreview()}>
<span>
{busy()
? 'Updating…'
: composer.sourceChanged()
? 'Source changed · update answer'
: composer.needsGeneration()
? 'Question changed · update answer'
: preview().sql !== composer.sql().trim()
? 'SQL changed · run SQL'
: 'Previous answer'}
</span>
</Show>
<Show when={!needsGeneration()}>
<button
type="button"
aria-label="Refresh answer"
title="Refresh answer"
disabled={busy() || !sourceAvailable()}
class="rounded p-1 text-ink-muted hover:bg-hover hover:text-ink disabled:opacity-40"
onClick={() =>
fireAndForget(composer.run(), 'database-query')
}
>
<ArrowClockwiseIcon class="size-3.5" />
</button>
</Show>
</div>
</div>
<div classList={{ 'opacity-50': !composer.isCurrentPreview() }}>
<QueryResults
answer={preview().answer}
displayMode={displayMode()}
chart={composer.presentation().chart}
names={names()}
display={display}
/>
</div>
<Show when={canAccept()}>
<div class="flex flex-wrap items-center justify-end gap-2 border-t border-edge-muted pt-3">
<Button variant="ghost" size="sm" onClick={editPrompt}>
Edit
</Button>
<Button variant="primary" size="sm" onClick={accept}>
{props.saveLabel ?? 'Insert'}
<Hotkey shortcut="enter" theme="current" aria-hidden="true" />
</Button>
</div>
</Show>
</div>
)}
</Show>
</div>
);
}