r2r.ipynb

{
  "cells": [
    {
      "cell_type": "code",
      "execution_count": 2,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "6QDo-i37wOeN",
        "outputId": "f64b9cc7-7fb6-4161-b7f5-08c44a55aecd"
      },
      "outputs": [],
      "source": [
        "# !git clone https://github.com/bennokr/rdflib-r2r.git\n",
        "# !pip install ./rdflib-r2r"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 3,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "t4E7PHQcwsfp",
        "outputId": "bc1a5c2b-afc3-4797-95f1-3a831643df98"
      },
      "outputs": [
        {
          "name": "stderr",
          "output_type": "stream",
          "text": [
            "/var/folders/jd/y6jxdm1s23l3qtl8w9js19880000gn/T/ipykernel_39079/2757565334.py:15: SADeprecationWarning: The _ConnectionFairy.connection attribute is deprecated; please use 'driver_connection' (deprecated since: 2.0)\n",
            "  if hasattr(conn.connection, \"c\"):\n",
            "/Users/vickyli117/Desktop/rdflib-r2r/rdflib_r2r/r2r_store.py:672: SAWarning: SELECT statement has a cartesian product between FROM element(s) \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\" and FROM element \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".  Apply join condition(s) between each element to resolve.\n",
            "  rows = list(conn.execute(query))\n"
          ]
        },
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "@prefix ns1: <http://example.com/emp#> .\n",
            "@prefix ns2: <http://example.com/dept#> .\n",
            "@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .\n",
            "\n",
            "<http://example.com/emp/7369> a <http://example.com/emp/etype/PART_TIME>,\n",
            "        <http://example.com/emp/job/CLERK> ;\n",
            "    ns1:c_ref_deptno [ ns2:COMPANY \"EXAMPLE Corporation\" ;\n",
            "            ns2:deptno 10 ;\n",
            "            ns2:location \"NEW YORK\" ;\n",
            "            ns2:name \"APPSERVER\" ] ;\n",
            "    ns1:deptNum 10 ;\n",
            "    ns1:empno 7369 ;\n",
            "    ns1:emptype <http://example.com/emp/etype/PART_TIME> ;\n",
            "    ns1:etype \"PART_TIME\" ;\n",
            "    ns1:job \"CLERK\" ;\n",
            "    ns1:jobtype <http://example.com/emp/job/CLERK> ;\n",
            "    ns1:name \"SMITH\" .\n",
            "\n",
            "\n"
          ]
        },
        {
          "data": {
            "text/plain": [
              "[('_:Department10',\n",
              "  '<http://example.com/dept#COMPANY>',\n",
              "  '\"EXAMPLE Corporation\"'),\n",
              " ('_:Department10', '<http://example.com/dept#deptno>', 10),\n",
              " ('_:Department10', '<http://example.com/dept#location>', 'NEW YORK'),\n",
              " ('_:Department10', '<http://example.com/dept#name>', 'APPSERVER'),\n",
              " ('<http://example.com/emp/7369>', '<http://example.com/emp#job>', 'CLERK'),\n",
              " ('<http://example.com/emp/7369>',\n",
              "  '<http://example.com/emp#etype>',\n",
              "  'PART_TIME'),\n",
              " ('<http://example.com/emp/7369>', '<http://example.com/emp#name>', 'SMITH'),\n",
              " ('<http://example.com/emp/7369>',\n",
              "  '<http://example.com/emp#c_ref_deptno>',\n",
              "  '_:Department10'),\n",
              " ('<http://example.com/emp/7369>',\n",
              "  '<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>',\n",
              "  '<http://example.com/emp/job/CLERK>'),\n",
              " ('<http://example.com/emp/7369>',\n",
              "  '<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>',\n",
              "  '<http://example.com/emp/etype/PART_TIME>'),\n",
              " ('<http://example.com/emp/7369>',\n",
              "  '<http://example.com/emp#jobtype>',\n",
              "  '<http://example.com/emp/job/CLERK>'),\n",
              " ('<http://example.com/emp/7369>',\n",
              "  '<http://example.com/emp#emptype>',\n",
              "  '<http://example.com/emp/etype/PART_TIME>'),\n",
              " ('<http://example.com/emp/7369>', '<http://example.com/emp#empno>', 7369),\n",
              " ('<http://example.com/emp/7369>', '<http://example.com/emp#deptNum>', 10)]"
            ]
          },
          "execution_count": 3,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "from rdflib_r2r import R2RStore, R2RMapping\n",
        "from sqlalchemy import create_engine\n",
        "from pathlib import Path\n",
        "import rdflib\n",
        "from rdflib.compare import to_isomorphic, graph_diff\n",
        "\n",
        "echo = False\n",
        "\n",
        "\n",
        "def create_database(db, path, *sql_fnames):\n",
        "    for sql_fname in sql_fnames:\n",
        "        sql_script = (path / sql_fname).open().read()\n",
        "        conn = db.raw_connection()\n",
        "        try:\n",
        "            if hasattr(conn.connection, \"c\"):\n",
        "                cursor = conn.connection.c\n",
        "            else:\n",
        "                cursor = conn.cursor()\n",
        "            cursor.execute(sql_script, (), None)\n",
        "        except Exception as e:\n",
        "            try:\n",
        "                cursor = conn.cursor()\n",
        "                cursor.executescript(sql_script)\n",
        "            except Exception as e:\n",
        "                raise Exception(f\"Problem with {path}: {e}\")\n",
        "            finally:\n",
        "                conn.close()\n",
        "        finally:\n",
        "            conn.close()\n",
        "\n",
        "# db = create_engine(\n",
        "#     \"duckdb:///:memory:\",\n",
        "#     echo=echo,\n",
        "#     # future=True,\n",
        "#     connect_args={\"read_only\": False},\n",
        "# )\n",
        "# db.dialect.server_version_info = (0,)\n",
        "\n",
        "import sqlite3\n",
        "db = create_engine(\n",
        "    \"sqlite:///:memory:\",\n",
        "    echo=echo,\n",
        "    future=True,\n",
        "    connect_args={\n",
        "        \"detect_types\": sqlite3.PARSE_DECLTYPES | sqlite3.PARSE_COLNAMES,\n",
        "        'timeout': 30 * 1000\n",
        "    },\n",
        "    native_datetime=False, # breaks rdb2rdf test D016\n",
        "    # native_datetime=True, # breaks BSBM test 3\n",
        ")\n",
        "\n",
        "# path = Path('rdflib-r2r/tests/rdb2rdf-ts/D014-3tables1primarykey1foreignkey')\n",
        "path = Path('tests/rdb2rdf-ts/D014-3tables1primarykey1foreignkey')\n",
        "sql_fname = 'create.sql'\n",
        "\n",
        "sql_script = (path / sql_fname).open().read()\n",
        "create_database(db, path, sql_fname)\n",
        "\n",
        "# Loads R2RML mapping\n",
        "mapfile = path / 'r2rmlb.ttl'\n",
        "fmt = rdflib.util.guess_format(str(mapfile))\n",
        "mapping = R2RMapping(rdflib.Graph().parse(str(mapfile), format=fmt))\n",
        "\n",
        "# Creates Direct Mapping from DB schema\n",
        "# mapping = R2RMapping.from_db(db)\n",
        "\n",
        "g_made = rdflib.Graph(R2RStore(db=db, mapping=mapping))\n",
        "print(to_isomorphic(g_made).serialize())\n",
        "\n",
        "query = g_made.store.getSQL(\"SELECT * WHERE {?s ?p ?o}\")\n",
        "# db.raw_connection().cursor().execute(\"SELECT * FROM DEPT\").fetchall()\n",
        "db.raw_connection().cursor().execute(query).fetchall()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 4,
      "metadata": {
        "id": "Xbvo-3lE14DA"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "SELECT anon_1.s AS s,\n",
            "       anon_1.p AS p\n",
            "FROM\n",
            "  (SELECT '_:' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".deptId AS VARCHAR) AS s,\n",
            "          '<http://example.com/dept#deptno>' AS p,\n",
            "          \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"deptno\" AS o,\n",
            "          NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('Department' || \"deptno\") AS deptId ,\n",
            "             \"deptno\" ,\n",
            "             \"dname\" ,\n",
            "             \"loc\"\n",
            "      FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"deptno\" = 'NEW YORK'\n",
            "   UNION ALL SELECT '_:' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".deptId AS VARCHAR) AS s,\n",
            "                    '<http://example.com/dept#location>' AS p,\n",
            "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"loc\" AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('Department' || \"deptno\") AS deptId ,\n",
            "             \"deptno\" ,\n",
            "             \"dname\" ,\n",
            "             \"loc\"\n",
            "      FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"loc\" = 'NEW YORK'\n",
            "   UNION ALL SELECT '_:' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".deptId AS VARCHAR) AS s,\n",
            "                    '<http://example.com/dept#name>' AS p,\n",
            "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"dname\" AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('Department' || \"deptno\") AS deptId ,\n",
            "             \"deptno\" ,\n",
            "             \"dname\" ,\n",
            "             \"loc\"\n",
            "      FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"dname\" = 'NEW YORK'\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://example.com/emp#job>' AS p,\n",
            "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"job\" AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"job\" = 'NEW YORK'\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://example.com/emp#name>' AS p,\n",
            "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"ename\" AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"ename\" = 'NEW YORK'\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://example.com/emp#c_ref_deptno>' AS p,\n",
            "                    '_:' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\".deptId AS VARCHAR) AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\",\n",
            "\n",
            "     (SELECT ('Department' || \"deptno\") AS deptId ,\n",
            "             \"deptno\" ,\n",
            "             \"dname\" ,\n",
            "             \"loc\"\n",
            "      FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\"\n",
            "   WHERE \"deptno\" = substr('NEW YORK', length('Department')+1)\n",
            "     AND \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"deptno\" = \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\".\"deptno\"\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://example.com/emp#empno>' AS p,\n",
            "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empno\" AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empno\" = 'NEW YORK'\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>' AS p,\n",
            "                    '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".jobTypeURI AS VARCHAR) || '>' AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"jobTypeURI\" = 'NEW YORK'\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>' AS p,\n",
            "                    '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empTypeURI AS VARCHAR) || '>' AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empTypeURI\" = 'NEW YORK'\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://example.com/emp#jobtype>' AS p,\n",
            "                    '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".jobTypeURI AS VARCHAR) || '>' AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"jobTypeURI\" = 'NEW YORK'\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://example.com/emp#emptype>' AS p,\n",
            "                    '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empTypeURI AS VARCHAR) || '>' AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empTypeURI\" = 'NEW YORK'\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://example.com/emp#etype>' AS p,\n",
            "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"etype\" AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"etype\" = 'NEW YORK'\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://example.com/emp#deptNum>' AS p,\n",
            "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"deptno\" AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"deptno\" = 'NEW YORK') AS anon_1\n"
          ]
        },
        {
          "ename": "OperationalError",
          "evalue": "ambiguous column name: deptno",
          "output_type": "error",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mOperationalError\u001b[0m                          Traceback (most recent call last)",
            "\u001b[1;32m/Users/vickyli117/Desktop/rdflib-r2r/r2r.ipynb Cell 3\u001b[0m in \u001b[0;36m4\n\u001b[1;32m      <a href='vscode-notebook-cell:/Users/vickyli117/Desktop/rdflib-r2r/r2r.ipynb#W2sZmlsZQ%3D%3D?line=1'>2</a>\u001b[0m \u001b[39mprint\u001b[39m(query)\n\u001b[1;32m      <a href='vscode-notebook-cell:/Users/vickyli117/Desktop/rdflib-r2r/r2r.ipynb#W2sZmlsZQ%3D%3D?line=2'>3</a>\u001b[0m \u001b[39m# db.raw_connection().cursor().execute(\"SELECT * FROM DEPT\").fetchall()\u001b[39;00m\n\u001b[0;32m----> <a href='vscode-notebook-cell:/Users/vickyli117/Desktop/rdflib-r2r/r2r.ipynb#W2sZmlsZQ%3D%3D?line=3'>4</a>\u001b[0m db\u001b[39m.\u001b[39;49mraw_connection()\u001b[39m.\u001b[39;49mcursor()\u001b[39m.\u001b[39;49mexecute(query)\u001b[39m.\u001b[39mfetchall()\n",
            "\u001b[0;31mOperationalError\u001b[0m: ambiguous column name: deptno"
          ]
        }
      ],
      "source": [
        "query = g_made.store.getSQL(\"SELECT * WHERE {?s ?p \\\"NEW YORK\\\"}\")\n",
        "print(query)\n",
        "# db.raw_connection().cursor().execute(\"SELECT * FROM DEPT\").fetchall()\n",
        "db.raw_connection().cursor().execute(query).fetchall()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 7,
      "metadata": {},
      "outputs": [
        {
          "data": {
            "text/plain": [
              "[]"
            ]
          },
          "execution_count": 7,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "newquery = \"\"\"\n",
        "SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
        "                    '<http://example.com/emp#c_ref_deptno>' AS p,\n",
        "                    '_:' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\".deptId AS VARCHAR) AS o,\n",
        "                    NULL AS g\n",
        "   FROM\n",
        "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
        "             \"empno\" ,\n",
        "             \"ename\" ,\n",
        "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
        "             \"job\" ,\n",
        "             \"deptno\" ,\n",
        "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
        "             \"etype\" ,\n",
        "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
        "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\",\n",
        "\n",
        "     (SELECT ('Department' || \"deptno\") AS deptId ,\n",
        "             \"deptno\" ,\n",
        "             \"dname\" ,\n",
        "             \"loc\"\n",
        "      FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\"\n",
        "   WHERE \"deptno\" = substr('NEW YORK', length('Department')+1)\n",
        "     AND \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"deptno\" = \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\".\"deptno\"\n",
        "\"\"\"\n",
        "db.raw_connection().cursor().execute(newquery).fetchall()   "
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 40,
      "metadata": {},
      "outputs": [
        {
          "data": {
            "text/plain": [
              "[('_:Department10', '<http://example.com/dept#location>', 'NEW YORK', None)]"
            ]
          },
          "execution_count": 40,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "newquery = \"\"\"\n",
        "SELECT '_:' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".deptId AS VARCHAR) AS s,\n",
        "          '<http://example.com/dept#location>' AS p,\n",
        "          \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"loc\" AS o,\n",
        "          NULL AS g\n",
        "   FROM\n",
        "     (SELECT ('Department' || \"deptno\") AS deptId ,\n",
        "             \"deptno\" ,\n",
        "             \"dname\" ,\n",
        "             \"loc\"\n",
        "      FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\"\n",
        "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"loc\" = 'NEW YORK'\n",
        "\"\"\"\n",
        "db.raw_connection().cursor().execute(newquery).fetchall() "
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 41,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 207
        },
        "id": "gdsiKbqs2OJc",
        "outputId": "bc20cad5-11ee-4437-d1c7-14adba140b99"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "[('_:Department10', '<http://example.com/dept#location>')]"
            ]
          },
          "execution_count": 41,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "newquery = \"\"\"\n",
        "SELECT anon_1.s AS s,\n",
        "       anon_1.p AS p\n",
        "FROM\n",
        "  (SELECT '_:' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".deptId AS VARCHAR) AS s,\n",
        "          '<http://example.com/dept#location>' AS p,\n",
        "          \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"loc\" AS o,\n",
        "          NULL AS g\n",
        "   FROM\n",
        "     (SELECT ('Department' || \"deptno\") AS deptId ,\n",
        "             \"deptno\" ,\n",
        "             \"dname\" ,\n",
        "             \"loc\"\n",
        "      FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\"\n",
        "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"loc\" = 'NEW YORK'\n",
        "   UNION ALL SELECT '_:' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".deptId AS VARCHAR) AS s,\n",
        "                    '<http://example.com/dept#name>' AS p,\n",
        "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"dname\" AS o,\n",
        "                    NULL AS g\n",
        "   FROM\n",
        "     (SELECT ('Department' || \"deptno\") AS deptId ,\n",
        "             \"deptno\" ,\n",
        "             \"dname\" ,\n",
        "             \"loc\"\n",
        "      FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\"\n",
        "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"dname\" = 'NEW YORK'\n",
        "   UNION ALL SELECT '_:' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".deptId AS VARCHAR) AS s,\n",
        "                    '<http://example.com/dept#deptno>' AS p,\n",
        "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"deptno\" AS o,\n",
        "                    NULL AS g\n",
        "   FROM\n",
        "     (SELECT ('Department' || \"deptno\") AS deptId ,\n",
        "             \"deptno\" ,\n",
        "             \"dname\" ,\n",
        "             \"loc\"\n",
        "      FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\"\n",
        "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"deptno\" = 'NEW YORK'\n",
        "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
        "                    '<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>' AS p,\n",
        "                    '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empTypeURI AS VARCHAR) || '>' AS o,\n",
        "                    NULL AS g\n",
        "   FROM\n",
        "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
        "             \"empno\" ,\n",
        "             \"ename\" ,\n",
        "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
        "             \"job\" ,\n",
        "             \"deptno\" ,\n",
        "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
        "             \"etype\" ,\n",
        "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
        "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
        "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empTypeURI\" = 'NEW YORK'\n",
        "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
        "                    '<http://example.com/emp#deptNum>' AS p,\n",
        "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"deptno\" AS o,\n",
        "                    NULL AS g\n",
        "   FROM\n",
        "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
        "             \"empno\" ,\n",
        "             \"ename\" ,\n",
        "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
        "             \"job\" ,\n",
        "             \"deptno\" ,\n",
        "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
        "             \"etype\" ,\n",
        "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
        "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
        "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"deptno\" = 'NEW YORK'\n",
        "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
        "                    '<http://example.com/emp#etype>' AS p,\n",
        "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"etype\" AS o,\n",
        "                    NULL AS g\n",
        "   FROM\n",
        "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
        "             \"empno\" ,\n",
        "             \"ename\" ,\n",
        "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
        "             \"job\" ,\n",
        "             \"deptno\" ,\n",
        "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
        "             \"etype\" ,\n",
        "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
        "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
        "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"etype\" = 'NEW YORK'\n",
        "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
        "                    '<http://example.com/emp#emptype>' AS p,\n",
        "                    '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empTypeURI AS VARCHAR) || '>' AS o,\n",
        "                    NULL AS g\n",
        "   FROM\n",
        "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
        "             \"empno\" ,\n",
        "             \"ename\" ,\n",
        "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
        "             \"job\" ,\n",
        "             \"deptno\" ,\n",
        "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
        "             \"etype\" ,\n",
        "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
        "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
        "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empTypeURI\" = 'NEW YORK'\n",
        "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
        "                    '<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>' AS p,\n",
        "                    '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".jobTypeURI AS VARCHAR) || '>' AS o,\n",
        "                    NULL AS g\n",
        "   FROM\n",
        "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
        "             \"empno\" ,\n",
        "             \"ename\" ,\n",
        "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
        "             \"job\" ,\n",
        "             \"deptno\" ,\n",
        "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
        "             \"etype\" ,\n",
        "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
        "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
        "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"jobTypeURI\" = 'NEW YORK'\n",
        "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
        "                    '<http://example.com/emp#c_ref_deptno>' AS p,\n",
        "                    '_:' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\".deptId AS VARCHAR) AS o,\n",
        "                    NULL AS g\n",
        "   FROM\n",
        "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
        "             \"empno\" ,\n",
        "             \"ename\" ,\n",
        "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
        "             \"job\" ,\n",
        "             \"deptno\" ,\n",
        "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
        "             \"etype\" ,\n",
        "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
        "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\",\n",
        "\n",
        "     (SELECT ('Department' || \"deptno\") AS deptId ,\n",
        "             \"deptno\" ,\n",
        "             \"dname\" ,\n",
        "             \"loc\"\n",
        "      FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\"\n",
        "   WHERE \"loc\" = substr('NEW YORK', length('Department')+1)\n",
        "     AND \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"deptno\" = \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\".\"deptno\"\n",
        "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
        "                    '<http://example.com/emp#jobtype>' AS p,\n",
        "                    '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".jobTypeURI AS VARCHAR) || '>' AS o,\n",
        "                    NULL AS g\n",
        "   FROM\n",
        "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
        "             \"empno\" ,\n",
        "             \"ename\" ,\n",
        "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
        "             \"job\" ,\n",
        "             \"deptno\" ,\n",
        "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
        "             \"etype\" ,\n",
        "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
        "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
        "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"jobTypeURI\" = 'NEW YORK'\n",
        "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
        "                    '<http://example.com/emp#empno>' AS p,\n",
        "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empno\" AS o,\n",
        "                    NULL AS g\n",
        "   FROM\n",
        "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
        "             \"empno\" ,\n",
        "             \"ename\" ,\n",
        "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
        "             \"job\" ,\n",
        "             \"deptno\" ,\n",
        "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
        "             \"etype\" ,\n",
        "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
        "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
        "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empno\" = 'NEW YORK'\n",
        "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
        "                    '<http://example.com/emp#job>' AS p,\n",
        "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"job\" AS o,\n",
        "                    NULL AS g\n",
        "   FROM\n",
        "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
        "             \"empno\" ,\n",
        "             \"ename\" ,\n",
        "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
        "             \"job\" ,\n",
        "             \"deptno\" ,\n",
        "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
        "             \"etype\" ,\n",
        "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
        "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
        "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"job\" = 'NEW YORK'\n",
        "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
        "                    '<http://example.com/emp#name>' AS p,\n",
        "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"ename\" AS o,\n",
        "                    NULL AS g\n",
        "   FROM\n",
        "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
        "             \"empno\" ,\n",
        "             \"ename\" ,\n",
        "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
        "             \"job\" ,\n",
        "             \"deptno\" ,\n",
        "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
        "             \"etype\" ,\n",
        "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
        "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
        "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"ename\" = 'NEW YORK') AS anon_1\n",
        "\"\"\"\n",
        "db.raw_connection().cursor().execute(newquery).fetchall()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 8,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "gypPN5IqzQuJ",
        "outputId": "1928e6d4-58fa-411e-eff9-d65a8521955d"
      },
      "outputs": [
        {
          "ename": "OperationalError",
          "evalue": "(sqlite3.OperationalError) ambiguous column name: deptno\n[SQL: SELECT anon_1.s AS s, anon_1.p AS p, anon_1.o AS o, anon_1.g AS g \nFROM (SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".deptId AS VARCHAR) AS s, '<http://example.com/dept#deptno>' AS p, \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"deptno\" AS o, NULL AS g \nFROM (SELECT ('Department' || \"deptno\") AS deptId\n            , \"deptno\"\n            , \"dname\"\n            , \"loc\"\n       FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"deptno\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".deptId AS VARCHAR) AS s, '<http://example.com/dept#location>' AS p, \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"loc\" AS o, NULL AS g \nFROM (SELECT ('Department' || \"deptno\") AS deptId\n            , \"deptno\"\n            , \"dname\"\n            , \"loc\"\n       FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"loc\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".deptId AS VARCHAR) AS s, '<http://example.com/dept#name>' AS p, \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"dname\" AS o, NULL AS g \nFROM (SELECT ('Department' || \"deptno\") AS deptId\n            , \"deptno\"\n            , \"dname\"\n            , \"loc\"\n       FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"dname\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://example.com/emp#empno>' AS p, \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empno\" AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empno\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://example.com/emp#deptNum>' AS p, \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"deptno\" AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"deptno\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://example.com/emp#name>' AS p, \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"ename\" AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"ename\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://example.com/emp#jobtype>' AS p, ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".jobTypeURI AS VARCHAR) || ? AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"jobTypeURI\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://example.com/emp#job>' AS p, \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"job\" AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"job\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://example.com/emp#etype>' AS p, \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"etype\" AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"etype\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://example.com/emp#c_ref_deptno>' AS p, ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\".deptId AS VARCHAR) AS o, NULL AS g \nFROM (SELECT ('Department' || \"deptno\") AS deptId\n            , \"deptno\"\n            , \"dname\"\n            , \"loc\"\n       FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\", (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"deptno\" = substr(?,length('Department')+1) AND \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"deptno\" = \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\".\"deptno\" UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>' AS p, ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empTypeURI AS VARCHAR) || ? AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empTypeURI\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>' AS p, ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".jobTypeURI AS VARCHAR) || ? AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"jobTypeURI\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://example.com/emp#emptype>' AS p, ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empTypeURI AS VARCHAR) || ? AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empTypeURI\" = ?) AS anon_1]\n[parameters: ('_:', 7369, '_:', 7369, '_:', 7369, '<', '>', 7369, '<', '>', 7369, '<', '>', 7369, '<', '>', '<', '>', 7369, '<', '>', 7369, '<', '>', 7369, '<', '>', '_:', 7369, '<', '>', '<', '>', 7369, '<', '>', '<', '>', 7369, '<', '>', '<', '>', 7369)]\n(Background on this error at: https://sqlalche.me/e/20/e3q8)",
          "output_type": "error",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mOperationalError\u001b[0m                          Traceback (most recent call last)",
            "File \u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py:1964\u001b[0m, in \u001b[0;36mConnection._exec_single_context\u001b[0;34m(self, dialect, context, statement, parameters)\u001b[0m\n\u001b[1;32m   1963\u001b[0m     \u001b[39mif\u001b[39;00m \u001b[39mnot\u001b[39;00m evt_handled:\n\u001b[0;32m-> 1964\u001b[0m         \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mdialect\u001b[39m.\u001b[39;49mdo_execute(\n\u001b[1;32m   1965\u001b[0m             cursor, str_statement, effective_parameters, context\n\u001b[1;32m   1966\u001b[0m         )\n\u001b[1;32m   1968\u001b[0m \u001b[39mif\u001b[39;00m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_has_events \u001b[39mor\u001b[39;00m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mengine\u001b[39m.\u001b[39m_has_events:\n",
            "File \u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/sqlalchemy/engine/default.py:747\u001b[0m, in \u001b[0;36mDefaultDialect.do_execute\u001b[0;34m(self, cursor, statement, parameters, context)\u001b[0m\n\u001b[1;32m    746\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39mdo_execute\u001b[39m(\u001b[39mself\u001b[39m, cursor, statement, parameters, context\u001b[39m=\u001b[39m\u001b[39mNone\u001b[39;00m):\n\u001b[0;32m--> 747\u001b[0m     cursor\u001b[39m.\u001b[39;49mexecute(statement, parameters)\n",
            "\u001b[0;31mOperationalError\u001b[0m: ambiguous column name: deptno",
            "\nThe above exception was the direct cause of the following exception:\n",
            "\u001b[0;31mOperationalError\u001b[0m                          Traceback (most recent call last)",
            "\u001b[1;32m/Users/vickyli117/Desktop/rdflib-r2r/r2r.ipynb Cell 5\u001b[0m in \u001b[0;36m3\n\u001b[1;32m      <a href='vscode-notebook-cell:/Users/vickyli117/Desktop/rdflib-r2r/r2r.ipynb#W4sZmlsZQ%3D%3D?line=0'>1</a>\u001b[0m o \u001b[39m=\u001b[39m rdflib\u001b[39m.\u001b[39mterm\u001b[39m.\u001b[39mLiteral(\u001b[39m'\u001b[39m\u001b[39m7369\u001b[39m\u001b[39m'\u001b[39m, datatype\u001b[39m=\u001b[39mrdflib\u001b[39m.\u001b[39mterm\u001b[39m.\u001b[39mURIRef(\u001b[39m'\u001b[39m\u001b[39mhttp://www.w3.org/2001/XMLSchema#integer\u001b[39m\u001b[39m'\u001b[39m))\n\u001b[1;32m      <a href='vscode-notebook-cell:/Users/vickyli117/Desktop/rdflib-r2r/r2r.ipynb#W4sZmlsZQ%3D%3D?line=1'>2</a>\u001b[0m \u001b[39m#o = rdflib.term.Literal('NEW YORK')\u001b[39;00m\n\u001b[0;32m----> <a href='vscode-notebook-cell:/Users/vickyli117/Desktop/rdflib-r2r/r2r.ipynb#W4sZmlsZQ%3D%3D?line=2'>3</a>\u001b[0m \u001b[39mlist\u001b[39;49m(g_made\u001b[39m.\u001b[39;49mtriples([\u001b[39mNone\u001b[39;49;00m, \u001b[39mNone\u001b[39;49;00m, o]))\n",
            "File \u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/rdflib/graph.py:530\u001b[0m, in \u001b[0;36mGraph.triples\u001b[0;34m(self, triple)\u001b[0m\n\u001b[1;32m    526\u001b[0m         \u001b[39myield\u001b[39;00m _s, p, _o\n\u001b[1;32m    527\u001b[0m \u001b[39melse\u001b[39;00m:\n\u001b[1;32m    528\u001b[0m     \u001b[39m# type error: Argument 1 to \"triples\" of \"Store\" has incompatible type \"Tuple[Optional[Node], Optional[Node], Optional[Node]]\"; expected \"Tuple[Optional[IdentifiedNode], Optional[IdentifiedNode], Optional[Node]]\"\u001b[39;00m\n\u001b[1;32m    529\u001b[0m     \u001b[39m# NOTE on type error: This is because the store typing is too narrow, willbe fixed in subsequent PR.\u001b[39;00m\n\u001b[0;32m--> 530\u001b[0m     \u001b[39mfor\u001b[39;00m (_s, _p, _o), cg \u001b[39min\u001b[39;00m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m__store\u001b[39m.\u001b[39mtriples((s, p, o), context\u001b[39m=\u001b[39m\u001b[39mself\u001b[39m):  \u001b[39m# type: ignore  [arg-type]\u001b[39;00m\n\u001b[1;32m    531\u001b[0m         \u001b[39myield\u001b[39;00m _s, _p, _o\n",
            "File \u001b[0;32m~/Desktop/rdflib-r2r/rdflib_r2r/r2r_store.py:672\u001b[0m, in \u001b[0;36mR2RStore.triples\u001b[0;34m(self, pattern, context)\u001b[0m\n\u001b[1;32m    669\u001b[0m     query \u001b[39m=\u001b[39m select(\u001b[39m*\u001b[39monlycols)\n\u001b[1;32m    671\u001b[0m \u001b[39m# logging.warn('final query:' + sql_pretty(query))\u001b[39;00m\n\u001b[0;32m--> 672\u001b[0m rows \u001b[39m=\u001b[39m \u001b[39mlist\u001b[39m(conn\u001b[39m.\u001b[39;49mexecute(query))\n\u001b[1;32m    673\u001b[0m \u001b[39mfor\u001b[39;00m s, p, o, g \u001b[39min\u001b[39;00m rows:\n\u001b[1;32m    674\u001b[0m     gnode \u001b[39m=\u001b[39m from_n3(g)\n",
            "File \u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py:1414\u001b[0m, in \u001b[0;36mConnection.execute\u001b[0;34m(self, statement, parameters, execution_options)\u001b[0m\n\u001b[1;32m   1412\u001b[0m     \u001b[39mraise\u001b[39;00m exc\u001b[39m.\u001b[39mObjectNotExecutableError(statement) \u001b[39mfrom\u001b[39;00m \u001b[39merr\u001b[39;00m\n\u001b[1;32m   1413\u001b[0m \u001b[39melse\u001b[39;00m:\n\u001b[0;32m-> 1414\u001b[0m     \u001b[39mreturn\u001b[39;00m meth(\n\u001b[1;32m   1415\u001b[0m         \u001b[39mself\u001b[39;49m,\n\u001b[1;32m   1416\u001b[0m         distilled_parameters,\n\u001b[1;32m   1417\u001b[0m         execution_options \u001b[39mor\u001b[39;49;00m NO_OPTIONS,\n\u001b[1;32m   1418\u001b[0m     )\n",
            "File \u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/sqlalchemy/sql/elements.py:485\u001b[0m, in \u001b[0;36mClauseElement._execute_on_connection\u001b[0;34m(self, connection, distilled_params, execution_options)\u001b[0m\n\u001b[1;32m    483\u001b[0m     \u001b[39mif\u001b[39;00m TYPE_CHECKING:\n\u001b[1;32m    484\u001b[0m         \u001b[39massert\u001b[39;00m \u001b[39misinstance\u001b[39m(\u001b[39mself\u001b[39m, Executable)\n\u001b[0;32m--> 485\u001b[0m     \u001b[39mreturn\u001b[39;00m connection\u001b[39m.\u001b[39;49m_execute_clauseelement(\n\u001b[1;32m    486\u001b[0m         \u001b[39mself\u001b[39;49m, distilled_params, execution_options\n\u001b[1;32m    487\u001b[0m     )\n\u001b[1;32m    488\u001b[0m \u001b[39melse\u001b[39;00m:\n\u001b[1;32m    489\u001b[0m     \u001b[39mraise\u001b[39;00m exc\u001b[39m.\u001b[39mObjectNotExecutableError(\u001b[39mself\u001b[39m)\n",
            "File \u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py:1638\u001b[0m, in \u001b[0;36mConnection._execute_clauseelement\u001b[0;34m(self, elem, distilled_parameters, execution_options)\u001b[0m\n\u001b[1;32m   1626\u001b[0m compiled_cache: Optional[CompiledCacheType] \u001b[39m=\u001b[39m execution_options\u001b[39m.\u001b[39mget(\n\u001b[1;32m   1627\u001b[0m     \u001b[39m\"\u001b[39m\u001b[39mcompiled_cache\u001b[39m\u001b[39m\"\u001b[39m, \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mengine\u001b[39m.\u001b[39m_compiled_cache\n\u001b[1;32m   1628\u001b[0m )\n\u001b[1;32m   1630\u001b[0m compiled_sql, extracted_params, cache_hit \u001b[39m=\u001b[39m elem\u001b[39m.\u001b[39m_compile_w_cache(\n\u001b[1;32m   1631\u001b[0m     dialect\u001b[39m=\u001b[39mdialect,\n\u001b[1;32m   1632\u001b[0m     compiled_cache\u001b[39m=\u001b[39mcompiled_cache,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m   1636\u001b[0m     linting\u001b[39m=\u001b[39m\u001b[39mself\u001b[39m\u001b[39m.\u001b[39mdialect\u001b[39m.\u001b[39mcompiler_linting \u001b[39m|\u001b[39m compiler\u001b[39m.\u001b[39mWARN_LINTING,\n\u001b[1;32m   1637\u001b[0m )\n\u001b[0;32m-> 1638\u001b[0m ret \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_execute_context(\n\u001b[1;32m   1639\u001b[0m     dialect,\n\u001b[1;32m   1640\u001b[0m     dialect\u001b[39m.\u001b[39;49mexecution_ctx_cls\u001b[39m.\u001b[39;49m_init_compiled,\n\u001b[1;32m   1641\u001b[0m     compiled_sql,\n\u001b[1;32m   1642\u001b[0m     distilled_parameters,\n\u001b[1;32m   1643\u001b[0m     execution_options,\n\u001b[1;32m   1644\u001b[0m     compiled_sql,\n\u001b[1;32m   1645\u001b[0m     distilled_parameters,\n\u001b[1;32m   1646\u001b[0m     elem,\n\u001b[1;32m   1647\u001b[0m     extracted_params,\n\u001b[1;32m   1648\u001b[0m     cache_hit\u001b[39m=\u001b[39;49mcache_hit,\n\u001b[1;32m   1649\u001b[0m )\n\u001b[1;32m   1650\u001b[0m \u001b[39mif\u001b[39;00m has_events:\n\u001b[1;32m   1651\u001b[0m     \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mdispatch\u001b[39m.\u001b[39mafter_execute(\n\u001b[1;32m   1652\u001b[0m         \u001b[39mself\u001b[39m,\n\u001b[1;32m   1653\u001b[0m         elem,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m   1657\u001b[0m         ret,\n\u001b[1;32m   1658\u001b[0m     )\n",
            "File \u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py:1842\u001b[0m, in \u001b[0;36mConnection._execute_context\u001b[0;34m(self, dialect, constructor, statement, parameters, execution_options, *args, **kw)\u001b[0m\n\u001b[1;32m   1837\u001b[0m     \u001b[39mreturn\u001b[39;00m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_exec_insertmany_context(\n\u001b[1;32m   1838\u001b[0m         dialect,\n\u001b[1;32m   1839\u001b[0m         context,\n\u001b[1;32m   1840\u001b[0m     )\n\u001b[1;32m   1841\u001b[0m \u001b[39melse\u001b[39;00m:\n\u001b[0;32m-> 1842\u001b[0m     \u001b[39mreturn\u001b[39;00m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_exec_single_context(\n\u001b[1;32m   1843\u001b[0m         dialect, context, statement, parameters\n\u001b[1;32m   1844\u001b[0m     )\n",
            "File \u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py:1983\u001b[0m, in \u001b[0;36mConnection._exec_single_context\u001b[0;34m(self, dialect, context, statement, parameters)\u001b[0m\n\u001b[1;32m   1980\u001b[0m     result \u001b[39m=\u001b[39m context\u001b[39m.\u001b[39m_setup_result_proxy()\n\u001b[1;32m   1982\u001b[0m \u001b[39mexcept\u001b[39;00m \u001b[39mBaseException\u001b[39;00m \u001b[39mas\u001b[39;00m e:\n\u001b[0;32m-> 1983\u001b[0m     \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_handle_dbapi_exception(\n\u001b[1;32m   1984\u001b[0m         e, str_statement, effective_parameters, cursor, context\n\u001b[1;32m   1985\u001b[0m     )\n\u001b[1;32m   1987\u001b[0m \u001b[39mreturn\u001b[39;00m result\n",
            "File \u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py:2325\u001b[0m, in \u001b[0;36mConnection._handle_dbapi_exception\u001b[0;34m(self, e, statement, parameters, cursor, context, is_sub_exec)\u001b[0m\n\u001b[1;32m   2323\u001b[0m \u001b[39melif\u001b[39;00m should_wrap:\n\u001b[1;32m   2324\u001b[0m     \u001b[39massert\u001b[39;00m sqlalchemy_exception \u001b[39mis\u001b[39;00m \u001b[39mnot\u001b[39;00m \u001b[39mNone\u001b[39;00m\n\u001b[0;32m-> 2325\u001b[0m     \u001b[39mraise\u001b[39;00m sqlalchemy_exception\u001b[39m.\u001b[39mwith_traceback(exc_info[\u001b[39m2\u001b[39m]) \u001b[39mfrom\u001b[39;00m \u001b[39me\u001b[39;00m\n\u001b[1;32m   2326\u001b[0m \u001b[39melse\u001b[39;00m:\n\u001b[1;32m   2327\u001b[0m     \u001b[39massert\u001b[39;00m exc_info[\u001b[39m1\u001b[39m] \u001b[39mis\u001b[39;00m \u001b[39mnot\u001b[39;00m \u001b[39mNone\u001b[39;00m\n",
            "File \u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py:1964\u001b[0m, in \u001b[0;36mConnection._exec_single_context\u001b[0;34m(self, dialect, context, statement, parameters)\u001b[0m\n\u001b[1;32m   1962\u001b[0m                 \u001b[39mbreak\u001b[39;00m\n\u001b[1;32m   1963\u001b[0m     \u001b[39mif\u001b[39;00m \u001b[39mnot\u001b[39;00m evt_handled:\n\u001b[0;32m-> 1964\u001b[0m         \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mdialect\u001b[39m.\u001b[39;49mdo_execute(\n\u001b[1;32m   1965\u001b[0m             cursor, str_statement, effective_parameters, context\n\u001b[1;32m   1966\u001b[0m         )\n\u001b[1;32m   1968\u001b[0m \u001b[39mif\u001b[39;00m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_has_events \u001b[39mor\u001b[39;00m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mengine\u001b[39m.\u001b[39m_has_events:\n\u001b[1;32m   1969\u001b[0m     \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mdispatch\u001b[39m.\u001b[39mafter_cursor_execute(\n\u001b[1;32m   1970\u001b[0m         \u001b[39mself\u001b[39m,\n\u001b[1;32m   1971\u001b[0m         cursor,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m   1975\u001b[0m         context\u001b[39m.\u001b[39mexecutemany,\n\u001b[1;32m   1976\u001b[0m     )\n",
            "File \u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/sqlalchemy/engine/default.py:747\u001b[0m, in \u001b[0;36mDefaultDialect.do_execute\u001b[0;34m(self, cursor, statement, parameters, context)\u001b[0m\n\u001b[1;32m    746\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39mdo_execute\u001b[39m(\u001b[39mself\u001b[39m, cursor, statement, parameters, context\u001b[39m=\u001b[39m\u001b[39mNone\u001b[39;00m):\n\u001b[0;32m--> 747\u001b[0m     cursor\u001b[39m.\u001b[39;49mexecute(statement, parameters)\n",
            "\u001b[0;31mOperationalError\u001b[0m: (sqlite3.OperationalError) ambiguous column name: deptno\n[SQL: SELECT anon_1.s AS s, anon_1.p AS p, anon_1.o AS o, anon_1.g AS g \nFROM (SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".deptId AS VARCHAR) AS s, '<http://example.com/dept#deptno>' AS p, \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"deptno\" AS o, NULL AS g \nFROM (SELECT ('Department' || \"deptno\") AS deptId\n            , \"deptno\"\n            , \"dname\"\n            , \"loc\"\n       FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"deptno\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".deptId AS VARCHAR) AS s, '<http://example.com/dept#location>' AS p, \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"loc\" AS o, NULL AS g \nFROM (SELECT ('Department' || \"deptno\") AS deptId\n            , \"deptno\"\n            , \"dname\"\n            , \"loc\"\n       FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"loc\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".deptId AS VARCHAR) AS s, '<http://example.com/dept#name>' AS p, \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"dname\" AS o, NULL AS g \nFROM (SELECT ('Department' || \"deptno\") AS deptId\n            , \"deptno\"\n            , \"dname\"\n            , \"loc\"\n       FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"dname\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://example.com/emp#empno>' AS p, \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empno\" AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empno\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://example.com/emp#deptNum>' AS p, \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"deptno\" AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"deptno\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://example.com/emp#name>' AS p, \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"ename\" AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"ename\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://example.com/emp#jobtype>' AS p, ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".jobTypeURI AS VARCHAR) || ? AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"jobTypeURI\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://example.com/emp#job>' AS p, \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"job\" AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"job\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://example.com/emp#etype>' AS p, \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"etype\" AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"etype\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://example.com/emp#c_ref_deptno>' AS p, ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\".deptId AS VARCHAR) AS o, NULL AS g \nFROM (SELECT ('Department' || \"deptno\") AS deptId\n            , \"deptno\"\n            , \"dname\"\n            , \"loc\"\n       FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\", (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"deptno\" = substr(?,length('Department')+1) AND \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"deptno\" = \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\".\"deptno\" UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>' AS p, ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empTypeURI AS VARCHAR) || ? AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empTypeURI\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>' AS p, ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".jobTypeURI AS VARCHAR) || ? AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"jobTypeURI\" = ? UNION ALL SELECT ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || ? AS s, '<http://example.com/emp#emptype>' AS p, ? || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empTypeURI AS VARCHAR) || ? AS o, NULL AS g \nFROM (SELECT ('http://example.com/emp/' || \"empno\") AS empURI\n            , \"empno\"\n            , \"ename\"\n            , ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI\n            , \"job\"\n            , \"deptno\"\n            , ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI\n            , \"etype\"\n            , ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n       FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\" \nWHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empTypeURI\" = ?) AS anon_1]\n[parameters: ('_:', 7369, '_:', 7369, '_:', 7369, '<', '>', 7369, '<', '>', 7369, '<', '>', 7369, '<', '>', '<', '>', 7369, '<', '>', 7369, '<', '>', 7369, '<', '>', '_:', 7369, '<', '>', '<', '>', 7369, '<', '>', '<', '>', 7369, '<', '>', '<', '>', 7369)]\n(Background on this error at: https://sqlalche.me/e/20/e3q8)"
          ]
        }
      ],
      "source": [
        "o = rdflib.term.Literal('7369', datatype=rdflib.term.URIRef('http://www.w3.org/2001/XMLSchema#integer'))\n",
        "#o = rdflib.term.Literal('NEW YORK')\n",
        "list(g_made.triples([None, None, o]))"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 7,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "y5BGKCQbwv3f",
        "outputId": "c1081350-072a-4f25-d3c7-4e6d8ad1c085"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "SELECT anon_1.s AS s,\n",
            "       anon_1.p AS p\n",
            "FROM\n",
            "  (SELECT '_:' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".deptId AS VARCHAR) AS s,\n",
            "          '<http://example.com/dept#deptno>' AS p,\n",
            "          \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"deptno\" AS o,\n",
            "          NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('Department' || \"deptno\") AS deptId ,\n",
            "             \"deptno\" ,\n",
            "             \"dname\" ,\n",
            "             \"loc\"\n",
            "      FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"deptno\" = 7369\n",
            "   UNION ALL SELECT '_:' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".deptId AS VARCHAR) AS s,\n",
            "                    '<http://example.com/dept#location>' AS p,\n",
            "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"loc\" AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('Department' || \"deptno\") AS deptId ,\n",
            "             \"deptno\" ,\n",
            "             \"dname\" ,\n",
            "             \"loc\"\n",
            "      FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"loc\" = 7369\n",
            "   UNION ALL SELECT '_:' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".deptId AS VARCHAR) AS s,\n",
            "                    '<http://example.com/dept#name>' AS p,\n",
            "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"dname\" AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('Department' || \"deptno\") AS deptId ,\n",
            "             \"deptno\" ,\n",
            "             \"dname\" ,\n",
            "             \"loc\"\n",
            "      FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR\".\"dname\" = 7369\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://example.com/emp#empno>' AS p,\n",
            "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empno\" AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empno\" = 7369\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://example.com/emp#deptNum>' AS p,\n",
            "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"deptno\" AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"deptno\" = 7369\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://example.com/emp#name>' AS p,\n",
            "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"ename\" AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"ename\" = 7369\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://example.com/emp#jobtype>' AS p,\n",
            "                    '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".jobTypeURI AS VARCHAR) || '>' AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"jobTypeURI\" = 7369\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://example.com/emp#job>' AS p,\n",
            "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"job\" AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"job\" = 7369\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://example.com/emp#etype>' AS p,\n",
            "                    \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"etype\" AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"etype\" = 7369\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://example.com/emp#c_ref_deptno>' AS p,\n",
            "                    '_:' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\".deptId AS VARCHAR) AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\",\n",
            "\n",
            "     (SELECT ('Department' || \"deptno\") AS deptId ,\n",
            "             \"deptno\" ,\n",
            "             \"dname\" ,\n",
            "             \"loc\"\n",
            "      FROM \"DEPT\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\"\n",
            "   WHERE \"deptno\" = substr(7369, length('Department')+1)\n",
            "     AND \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"deptno\" = \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BR_ref\".\"deptno\"\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>' AS p,\n",
            "                    '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empTypeURI AS VARCHAR) || '>' AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empTypeURI\" = 7369\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>' AS p,\n",
            "                    '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".jobTypeURI AS VARCHAR) || '>' AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"jobTypeURI\" = 7369\n",
            "   UNION ALL SELECT '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empURI AS VARCHAR) || '>' AS s,\n",
            "                    '<http://example.com/emp#emptype>' AS p,\n",
            "                    '<' || CAST(\"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".empTypeURI AS VARCHAR) || '>' AS o,\n",
            "                    NULL AS g\n",
            "   FROM\n",
            "     (SELECT ('http://example.com/emp/' || \"empno\") AS empURI ,\n",
            "             \"empno\" ,\n",
            "             \"ename\" ,\n",
            "             ('http://example.com/emp/job/'|| \"job\") AS jobTypeURI ,\n",
            "             \"job\" ,\n",
            "             \"deptno\" ,\n",
            "             ('http://example.com/emp/etype/'|| \"etype\") AS empTypeURI ,\n",
            "             \"etype\" ,\n",
            "             ('http://example.com/graph/'|| \"job\" || '/' || \"etype\") AS graphURI\n",
            "      FROM \"EMP\") AS \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\"\n",
            "   WHERE \"View_NB2HI4B2F4XWK6DBNVYGYZJOMNXW2L3CMFZWKL2UOJUXA3DFONGWC4BS\".\"empTypeURI\" = 7369) AS anon_1\n"
          ]
        }
      ],
      "source": [
        "print(g_made.store.getSQL(\"SELECT * WHERE {?s ?p 7369}\"))"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "WlQx1wAQy61G"
      },
      "outputs": [],
      "source": []
    }
  ],
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "display_name": "Python 3",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.9.5"
    },
    "vscode": {
      "interpreter": {
        "hash": "aee8b7b246df8f9039afb4144a1f6fd8d2ca17a180786b69acc140d282b71a49"
      }
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}