How is Prolog ideal for when you'd use SQL? I can understand it if you're talking about querying a CSV file, but the advantage to SQL is that the database with all your data natively supports SQL and it can usually run pretty fast.
Btw: what would it look like to query a small sample CSV file. Like the below example if you wanted to find all cars that are made by Ford?
Brand,Model,Year,Color/n
Ford,F150,1999,Black/n
Toyota,Yaris,2013,Yellow/n
Ford,Mustang,1969,Blue/n
Edit: sorry for not knowing how to format HN properly and show the newline on each of the rows.
Btw: what would it look like to query a small sample CSV file. Like the below example if you wanted to find all cars that are made by Ford?
Brand,Model,Year,Color/n Ford,F150,1999,Black/n Toyota,Yaris,2013,Yellow/n Ford,Mustang,1969,Blue/n
Edit: sorry for not knowing how to format HN properly and show the newline on each of the rows.