1 row where category = "Prof"

View and edit SQL

Link category op
Prof Prof

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "opposite_categories" (
	"category"	TEXT NOT NULL UNIQUE,
	"op"	TEXT NOT NULL CHECK("category" <= "op") UNIQUE,
	FOREIGN KEY("category") REFERENCES "categories"("name") on delete restrict on update cascade,
	PRIMARY KEY("category","op"),
	FOREIGN KEY("op") REFERENCES "categories"("name") on delete restrict on update cascade
);