Return JSON natively from Postgres in Python

schema.sql

CREATE TABLE author (
	id INTEGER NOT NULL, 
	name VARCHAR(255) NOT NULL, 
	PRIMARY KEY (id)
);

CREATE TABLE book (
	id INTEGER NOT NULL, 
	name VARCHAR(255) NOT NULL, 
	author_id INTEGER, 
	PRIMARY KEY (id), 
	FOREIGN KEY(author_id) REFERENCES author (id)
);