Using Python

import numpy as np
import pandas as pd
import os
import psycopg2

import shapely
import shapely.wkt
import geopandas as gpd

connection = psycopg2.connect(host = "postgis",database="gis_course",user="gis_course", password="gis_course123")

sql = "select geometry geom from crimes where crime_type like '%Viol%' and date between '2021-04-01' and '2021-05-01'"

df = gpd.GeoDataFrame.from_postgis(sql, connection)