/lisql

Write SQL directly in Commno Lisp, without using ORM.

Primary LanguageCommon LispMIT LicenseMIT

LiSQL

Usage

(ql:quickload :lisql)
(use-package :lisql)

(select * from account where id = "c49a8035-e59e-49ab-ad80-f51e2cd91001")
"SELECT * FROM ACCOUNT WHERE ID = 'c49a8035-e59e-49ab-ad80-f51e2cd91001'"

(insert into account (name) values ("cxxxr"))
"INSERT INTO ACCOUNT (NAME) VALUES ('cxxxr')"

with CL-DBI

https://github.com/fukamachi/cl-dbi

(defparameter *connection* (dbi:connect :sqlite3 :database-name "/foo/bar/test.sqlite3"))
(dbi:execute
  (dbi:prepare *connection*
    (lisql:SELECT * FROM somewhere WHERE id = ?)) ; <===
  (list "c49a8035-e59e-49ab-ad80-f51e2cd91001"))