Need smarter algorithm for (license) queries

License is one of the fields of the datasource table. When adding new entries, one will want to choose a license from that table. Finding the right license using pure SQL works, but not very well. One problematic example:

Using SQL ILIKE, no entry is found for "%Creative Commons Attribution Share-Alike 4.0%". However, there is an entry "Creative Commons Attribution Share Alike 4.0 International" in the database. It is not found because of the hyphen in the query string.

Contributions to making license querying smarter are very welcome! In fact, we may want to make querying smarter not just for licenses but for all of the tables.

Start by locating the license lookup against the datasource table and the SQL ILIKE query described in the issue. Compare the hyphenated Creative Commons example with the existing database value, then define and test a matching approach before deciding whether it should apply beyond licenses.

Written by the indexing model from the issue text.