semantiDan

SELECT `organization_name`, 
  `has_employee[person].person_id` AS person_id, 
  `has_employee[person].first_name` AS first_name, 
  `has_employee[person].last_name` AS last_name,
  `has_employee[person]_title` AS title
FROM dtimbr.advertising_company

semantiDan

CREATE OR REPLACE CONCEPT `advertising_company` 
 INHERITS (`company`) FROM `timbr`.`company` WHERE `category_code` = 'advertising';

semantiDan

SELECT `organization_name`, `has_acquired[company*3].organization_name`, `has_acquired[company*3]_transitivity_level`, `has_acquired[company*3].has_product[product].entity_label` AS `product`
FROM (SELECT `company`.`entity_id`, `company`.`entity_type`, `company`.`entity_label`, `company`.`organization_name`, `company`.`organization_id`, `has_acquired[company*3].has_product[product]`.`entity_label` AS `has_acquired[company*3].has_product[product].entity_label`, `has_acquired[company*3]`.`_transitivity_level` AS `has_acquired[company*3]_transitivity_level`, `has_acquired[company*3]`.`organization_name` AS `has_acquired[company*3].organization_name`
            FROM (SELECT CAST(`organization_id` AS CHAR) AS `entity_id`, 'company' AS `entity_type`, CAST(`organization_name` AS CHAR) AS `entity_label`, `organization_name`, `organization_id`
                        FROM (SELECT `category_code` AS `category_code`, `closed_at` AS `closed_at`, `first_funding_at` AS `first_funding_at`, `funding_rounds` AS `funding_roun

semantiDan

SELECT `organization_name`,
`has_acquired[company*3].organization_name`,
`has_acquired[company*3]_transitivity_level`,
`has_acquired[company*3].has_product[product].entity_label` AS product
FROM dtimbr.company
WHERE `organization_name` = 'Microsoft' AND `has_acquired[company*3].organization_name` IS NOT NULL
ORDER BY `has_acquired[company*3]_transitivity_level` ASC
LIMIT 1000

semantiDan

SELECT `organization_name`, `has_employee[person].person_id` AS `person_id`, `has_employee[person].first_name` AS `first_name`, `has_employee[person].last_name` AS `last_name`, `has_employee[person]_title` AS `title`
FROM (SELECT `advertising_company`.`entity_id`, `advertising_company`.`entity_type`, `advertising_company`.`organization_name`, `advertising_company`.`organization_id`, `has_employee[person]`.`first_name` AS `has_employee[person].first_name`, `has_employee[person]`.`last_name` AS `has_employee[person].last_name`, `has_employee[person]`.`person_id` AS `has_employee[person].person_id`, `works_at_1`.`title` AS `has_employee[person]_title`
            FROM (SELECT CAST(`organization_id` AS CHAR) AS `entity_id`, 'company' AS `entity_type`, `organization_name`, `organization_id`
                        FROM (SELECT `last_milestone_at`, `short_description`, `city`, `logo_url`, `last_funding_at`, `homepage_url`, `twitter_username`, `description`, `normalized_name`, `first_investment_at`, CAST(NULL AS SIG