// This to define the query
const myQuery = Effect.map(Connection, (sql) =>
Sql.schema.single({
Request: Schema.Unknown,
Result: Schema.Unknown,
execute: () => sql`SELECT 1`,
}),
);
// This to execute it
const result = yield* Effect.flatMap(myQuery, (query) => query());
// This to define the query
const myQuery = Effect.map(Connection, (sql) =>
Sql.schema.single({
Request: Schema.Unknown,
Result: Schema.Unknown,
execute: () => sql`SELECT 1`,
}),
);
// This to execute it
const result = yield* Effect.flatMap(myQuery, (query) => query());