SQL error received on `/report/advisories`

https://dependency-management-data-example.fly.dev/report/advisories is reporting:

sql: Scan error on column index 7, name "advisory_type": converting NULL to string is unsupported

https://dependency-management-data-example.fly.dev/datasette/dmd?sql=--+name%3A+RetrieveRenovateAdvisories+%3Amany%0D%0Aselect%0D%0A++r.platform%2C%0D%0A++r.organisation%2C%0D%0A++r.repo%2C%0D%0A++r.package_name%2C%0D%0A++r.version%2C%0D%0A++r.current_version%2C%0D%0A++r.dep_types%2C%0D%0A++advisory_type%2C%0D%0A++description%0D%0Afrom%0D%0A++renovate+r%0D%0A++inner+join+advisories+on+r.package_name+like+replace%28advisories.package_pattern%2C+%27*%27%2C+%27%25%27%29%0D%0Awhere%0D%0A%28%0D%0A+++case%0D%0A++++++when+version_match_strategy+IS+NULL+++++++++++then+true%0D%0A++++++when+version_match_strategy+%3D+%27ANY%27+++++++++++then+true%0D%0A++++++when+version_match_strategy+%3D+%27EQUAL%27+++++++++then+current_version+%3D+advisories.version%0D%0A++++++when+version_match_strategy+%3D+%27LESS_THAN%27+++++then+current_version+%3C+advisories.version%0D%0A++++++when+version_match_strategy+%3D+%27LESS_EQUAL%27++++then+current_version+%3C%3D+advisories.version%0D%0A++++++when+version_match_strategy+%3D+%27GREATER_THAN%27++then+current_version+%3E+advisories.version%0D%0A++++++when+version_match_strategy+%3D+%27GREATER_EQUAL%27+then+current_version+%3E%3D+advisories.version%0D%0A++++++else+false%0D%0A++++end%29%0D%0Aunion%0D%0Aselect%0D%0A++renovate.platform%2C%0D%0A++renovate.organisation%2C%0D%0A++renovate.repo%2C%0D%0A++e.package_name%2C%0D%0A++e.version%2C%0D%0A++e.current_version%2C%0D%0A++renovate.dep_types%2C%0D%0A++%28%0D%0A++++case%0D%0A++++++when+eol_from+is+not+null%0D%0A++++++and+%28cast+%28%28julianday%28eol_from%29+-+julianday%28%27now%27%29%29+as+integer%29%29%0D%0A+++++++++++%3C+0%0D%0A++++++++++then%0D%0A++++++++++++%27UNSUPPORTED%27%0D%0A++++++when+eol_from+is+not+null%0D%0A++++++and+%28cast+%28%28julianday%28eol_from%29+-+julianday%28%27now%27%29%29+as+integer%29%29%0D%0A+++++++++++%3C%3D+60%0D%0A+++++++++++then%0D%0A+++++++++++++%27DEPRECATED%27%0D%0A++++++when+supported_until+is+not+null%0D%0A++++++and+%28cast+%28%28julianday%28supported_until%29+-+julianday%28%27now%27%29%29+as+integer%29%29%0D%0A+++++++++++%3C+0%0D%0A++++++++++then%0D%0A+++++++++++++%27DEPRECATED%27%0D%0A++++++when+supported_until+is+not+null%0D%0A++++++and+%28cast+%28%28julianday%28supported_until%29+-+julianday%28%27now%27%29%29+as+integer%29%29%0D%0A+++++++++++%3C%3D+60%0D%0A+++++++++++then%0D%0A+++++++++++++%27DEPRECATED%27%0D%0A++++end%0D%0A++%29+as+advisory_type%2C%0D%0A++%28%0D%0A++++case%0D%0A++++++when+eol_from+is+not+null%0D%0A++++++and+%28cast+%28%28julianday%28eol_from%29+-+julianday%28%27now%27%29%29+as+integer%29%29%0D%0A+++++++++++%3C+0%0D%0A++++++++++then%0D%0A+++++++++++++e.product_name+%7C%7C+%27+%27+%7C%7C+e.cycle%0D%0A+++++++++++++++%7C%7C+%27+has+been+End-of-Life+for+%27%0D%0A+++++++++++++++%7C%7C+abs%28cast+%28%28julianday%28eol_from%29+-+julianday%28%27now%27%29%29+as+integer%29%29%0D%0A+++++++++++++++%7C%7C+%27+days%27%0D%0A++++++when+eol_from+is+not+null%0D%0A++++++and+%28cast+%28%28julianday%28eol_from%29+-+julianday%28%27now%27%29%29+as+integer%29%29%0D%0A+++++++++++%3C%3D+60%0D%0A+++++++++++then%0D%0A+++++++++++++e.product_name+%7C%7C+%27+%27+%7C%7C+e.cycle%0D%0A+++++++++++++++%7C%7C+%27+will+be+End-of-Life+in+%27%0D%0A+++++++++++++++%7C%7C+abs%28cast+%28%28julianday%28eol_from%29+-+julianday%28%27now%27%29%29+as+integer%29%29%0D%0A+++++++++++++++%7C%7C+%27+days%27%0D%0A++++++when+supported_until+is+not+null%0D%0A++++++and+%28cast+%28%28julianday%28supported_until%29+-+julianday%28%27now%27%29%29+as+integer%29%29%0D%0A+++++++++++%3C+0%0D%0A++++++++++then%0D%0A+++++++++++++e.product_name+%7C%7C+%27+%27+%7C%7C+e.cycle%0D%0A+++++++++++++++%7C%7C+%27+has+been+unsupported+%28usually+only+receiving+critical+security+fixes%29+for+%27%0D%0A+++++++++++++++%7C%7C+abs%28cast+%28%28julianday%28supported_until%29+-+julianday%28%27now%27%29%29+as+integer%29%29%0D%0A+++++++++++++++%7C%7C+%27+days%27%0D%0A++++++when+supported_until+is+not+null%0D%0A++++++and+%28cast+%28%28julianday%28supported_until%29+-+julianday%28%27now%27%29%29+as+integer%29%29%0D%0A+++++++++++%3C%3D+60%0D%0A+++++++++++then%0D%0A+++++++++++++e.product_name+%7C%7C+%27+%27+%7C%7C+e.cycle%0D%0A+++++++++++++++%7C%7C+%27+will+be+unsupported+%28usually+only+receiving+critical+security+fixes%29+in+%27%0D%0A+++++++++++++++%7C%7C+abs%28cast+%28%28julianday%28supported_until%29+-+julianday%28%27now%27%29%29+as+integer%29%29%0D%0A+++++++++++++++%7C%7C+%27+days%27%0D%0A++++end%0D%0A++%29+as+description%0D%0Afrom%0D%0A++renovate_endoflife+e%0D%0A++inner+join+endoflifedate_products+on+%28%0D%0A++++e.product_name+%3D+endoflifedate_products.product_name%0D%0A++++AND+e.cycle+%3D+endoflifedate_products.cycle%0D%0A++%29%0D%0A++inner+join+renovate+on+%28%0D%0A++++e.package_name+%3D+renovate.package_name%0D%0A++++AND+%28%0D%0A++++++e.version+%3D+renovate.version%0D%0A++++++AND+case%0D%0A++++++++when+e.current_version+is+NULL+then+true%0D%0A++++++++when+e.current_version+is+NOT+NULL+then+e.current_version+%3D+renovate.current_version%0D%0A++++++end%0D%0A++++%29%0D%0A++++AND+e.package_manager+%3D+renovate.package_manager%0D%0A++++AND+e.datasource+%3D+renovate.datasource%0D%0A++%29%0D%0Awhere%0D%0A++%28supported_until+is+not+null+or+eol_from+is+not+null%29%0D%0A++AND%0D%0A++%28%0D%0A++++%28%0D%0A++++++cast+%28%28julianday%28supported_until%29+-+julianday%28%27now%27%29%29+as+integer%29%0D%0A++++++%3C%3D+100%0D%0A++++%29%0D%0A++++OR%0D%0A++++%28%0D%0A++++++cast+%28%28julianday%28eol_from%29+-+julianday%28%27now%27%29%29+as+integer%29%0D%0A++++++%3C%3D+100%0D%0A++++%29%0D%0A++%29%0D%0Aorder+by+advisory_type%2C+platform%2C+organisation%2C+repo%2C+package_name%3B%0D%0A&many=&exec=

Edited by Jamie Tanna