SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select sqlite_version();


sqlite_version()


3.39.1


CREATE TABLE table_name (key1, key2, key3);
✓
INSERT INTO table_name VALUES (1,2,'foo');
✓
SELECT *
FROM table_name
WHERE (key1, key2, key3) IN ((1,2,'foo'), (3,4,'bar'));


key1
key2
key3


1
2
foo


SELECT *
FROM table_name
WHERE (key1, key2, key3) IN (SELECT * FROM (VALUES (1,2,'foo'), (3,4,'bar')));


key1
key2
key3


1
2
foo


SELECT *
FROM table_name
WHERE (key1, key2, key3) IN (
  SELECT 1,2,'foo'
  UNION ALL
  SELECT 3,4,'bar'
);


key1
key2
key3


1
2
foo


SELECT t.*
FROM table_name t
INNER JOIN (
  SELECT 1 key1, 2 key2, 'foo' key3
  UNION ALL
  SELECT 3,4,'bar'
) u ON u.key1 = t.key1 AND u.key2 = t.key2 AND u.key3 = t.key3;


key1
key2
key3


1
2
foo