I request an enhancement to FOREIGN KEYs as follows. The foreign key clause
<https://www.sqlite.org/syntax/foreign-key-clause.html> requires a definition as follows: REFERENCES foreign-table ( column-name [[, column-name]]) ... It would be useful if rather than having to specify a column name for each item one could specify a fixed value (or perhaps an expression, though that might be more complicated to handle). This means that, if some customers were dealers and others weren't you could ensure you gave discounts only to dealers using REFERENCES customers ('dealer', id) Simon.