KO | EN

GitLite

Minimalist Open Source Repository Search Engine

gitlite — search

#dsh #dsh-plugin #deepseek-harness #typescript #ai-agent #codex #developer-tools #claude-code #windows #mcp #python #desktop-app

jsqx

★ 47 Open GitHub ↗

Cursed lib to make SQL Queries in JSX (dont use this)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# JSQX
<img width="1510" alt="image" src="https://github.com/achrafl0/jsqx/assets/63306573/569c26bb-0031-4d53-b14a-ddeca5d02c02">

A cursed librairy to create SQL queries using JSX

## License

YOU CAN ONLY USE THIS LIBRAIRY IN PURELY COMMERCIAL PROJECTS.
I want to see this in prod
(for legal reasons this is a joke, you can use this whatever you want, just you know, a bit of credit would be nice)

## USAGE

```typescript

const query = (
  <Select table="Users" columns={["*"]} alias="u">
    <Where>
      <Clause clause={`u.id = ${author.id}`} />
      <Clause clause={`u.isAdmin = ${author.isAdmin}`} />
    </Where>
    <Sort column="createdAt" order="asc" />
    <Limit value={100} />
  </Select>
);

// With TypeORM
const rawData = await manager.query(query);

// With Prisma

const result = await prisma.$queryRaw(
  Prisma.sql`${query}`
)

```

## Testing

Didn't test, don't care, don't @ me

## TODO

- [ ] Support `UPDATE`
- [ ] Support `DELETE`
- [ ] Support `INSERT`
- [ ] Support Transactions (that's gonna be fun)

jsqx

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README