The "application" is out of support and yet the database is separate and updatable?  If at all possible I wouldn't touch a single thing.   If something breaks... better to treat...

Jeff's code seems to generate primary keys and produces the correct output afaik.  Creating foreign keys should be straightforward for the OP.  The split could be accomplished with OPENJSON without...

Why does this make sense?  CONVERT using style 2 seems to convert to text and removes the leading '0x'

select Modelnameid origignal
      ,cast(SUBSTRING(Modelnameid...

A good first step could be to run this code

select datepart(weekday, cast(getdate()+nums.n as date)) day_of_week_number, 
       datename(weekday, cast(getdate()+nums.n as date)) day_of_week
from...

Maybe you're looking for the SUM OVER the volume partitioned by the 'parent_id' column but which column is appropriate to ORDER BY?  If ORDER BY the 'filter_path' column it causes...

It's true.  It's available in Azure SQL compatibility level 150 (and above) and SQL Server 2022.  There are alternatives such...

drop table if exists #some_table;
go
create table #some_table (
  input_string varchar(200) not null);

insert #some_table(input_string) values
('5,1,6,1,69,1'),
('5,1,6,1,3,2,5,3,69,1');

select string_agg(iif((ss.ordinal-1)%2=0, concat('''', ss.[value], ''''), ss.[value]), ',')
      ...

Maybe something like this

drop table if exists #some_table;
go
create table #some_table (
  full_name_proper varchar(200) not null);

insert into #some_table values
('A'),
('A B'),
('A B C'),
('A B C D'),
('A B C...

You could try OPENJSON and provide the 2 column schema definition

declare @json           nvarchar(max)=N'[{"display":"Section1","value":"1"},{"display":"Section2","value":"2"}]';

select oj.[value], oj.display
from openjson(@json) 
...

The windowing function FIRST_VALUE returns the first value in an ordered set.  In this case PARTITION BY item_num ORDER BY revision.  You could use a CTE to UPDATE the column...

In SELECT statements the FROM clause and JOINs are evaluated first.  Maybe you could use the VALUES table value constructor to store (rows of) criteria, order number, and value.  Then...

At this point no I haven't downloaded the desktop app.  I did look around some more at the Blazor razor pages.  In that area in general you seem to be...

(another attempt to fight the anti-spam forum measures)

EF isn't used at all for the interesting parts. I just added it 2 weeks ago and it's only used by the...

The GitHub link is only visible in the footer of the demo/query section of the site

https://github.com/jtheisen/squil

Entity Framework is just used for configuration purposes, the actual data access during browsing...

Very interesting.  It looks impressive and the site works great.  The GitHub repo (+1 star'ed) is always the interesting part imo.  It seems maybe the project began a while ago...