Code
sqlite
-- Insert with parameterized placeholders (driver-specific)
INSERT INTO users (username, email) VALUES (?, ?);
-- Bulk insert via transaction
BEGIN;
INSERT INTO users (username, email) VALUES ('alice', 'a@b.com');
INSERT INTO users (username, email) VALUES ('bob', 'b@c.com');
INSERT INTO users (username, email) VALUES ('carol', 'c@d.com');
COMMIT;
-- Query with limit and ordering
SELECT id, username, created FROM users
ORDER BY created DESC LIMIT 10;
-- Search and aggregate
SELECT username FROM users WHERE email LIKE '%@example.com';
SELECT COUNT(*) AS total, MAX(created) AS latest FROM users;
-- Update and delete
UPDATE users SET email = 'new@x.com' WHERE id = 1;
DELETE FROM users WHERE id = 1;