I am using JDBC driver (org.neo4j.jdbc.bolt.BoltDriver) to connect to neo4j (jdbc link url : neo4j-jdbc-driver-link) . Could see we need to write SQL while executing query.
Can we write a SQL query instead of CQL like SELECT p.* FROM products as p;
?
No, it accepts only Cypher. There is no concept of tables in Neo4j. The docs are at https://neo4j-contrib.github.io/neo4j-jdbc/