SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE owners ( OwnerID INTEGER PRIMARY KEY AUTOINCREMENT, 
                      OwnerName TEXT, 
                      OwnerSurname TEXT );
✓
CREATE TABLE cats ( id INTEGER PRIMARY KEY AUTOINCREMENT, 
                    Name TEXT, 
                    ownerID INTEGER, 
                    specie TEXT, 
                    birthday DATE,
                    FOREIGN KEY (OwnerID) REFERENCES owners (OwnerID));
✓
INSERT INTO owners( OwnerName, ownerSurname)  
VALUES  
("Vasiliy", "Kotov"), 
("Ivan", "Progerov");
✓
INSERT INTO cats( Name, ownerID, specie,  birthday)  
SELECT "Pushock", OwnerID, "Scottish", '2020-07-02'
FROM owners
WHERE (OwnerName, ownerSurname) = ("Vasiliy", "Kotov");
✓
INSERT INTO cats( Name, ownerID, specie,  birthday)  
SELECT Name, ownerID, specie,  birthday
FROM ( SELECT "Barsic" Name, "Siberian" specie, '2015-04-12' birthday UNION ALL
       SELECT "Pascal", "Siberian", '2018-02-11' UNION ALL
       SELECT "Floppa", "Caracal", '2017-12-21' ) cats 
CROSS JOIN ( SELECT OwnerID
             FROM owners
             WHERE (OwnerName, ownerSurname) = ("Ivan", "Progerov")) owners;
✓
SELECT *
FROM owners 
JOIN cats USING (ownerID);


OwnerID
OwnerName
OwnerSurname
id
Name
specie
birthday


1
Vasiliy
Kotov
1
Pushock
Scottish
2020-07-02

2
Ivan
Progerov
2
Barsic
Siberian
2015-04-12

2
Ivan
Progerov
3
Pascal
Siberian
2018-02-11

2
Ivan
Progerov
4
Floppa
Caracal
2017-12-21

OwnerID	OwnerName	OwnerSurname	id	Name	specie	birthday
1	Vasiliy	Kotov	1	Pushock	Scottish	2020-07-02
2	Ivan	Progerov	2	Barsic	Siberian	2015-04-12
2	Ivan	Progerov	3	Pascal	Siberian	2018-02-11
2	Ivan	Progerov	4	Floppa	Caracal	2017-12-21